0

Append / Combine / lookup - two API Datasource which has different parameters

I want to connect two API data source which has different column and I want one column in one data source to use with another another data source  -

I tried lookup which not working 100% correct  like

lookup(e9a7a8a3355813c7092c52abe7c48ad9@/Items/ClientName;,2be76f6247be4846f5045a92cb3f3af1@/records/Name;,2be76f6247be4846f5045a92cb3f3af1@/records/Time_zone_for_live_calls__c;)

Its like

DS1 :  API Data source is having Client Name , Client Region.
DS2:  API Data Source is having Client Name , Created Month , Employee Count

I want to Graph where I can show Month wise Employee Count for every Client Region  as seperate line

My main issue is connecting two data source perfectly I want Client Region of DS1 map properly with DS2 [As of now lookup is working but not giving proper result ,  not ploted all monthly data]

 

5 comments

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Gopal,

    Thanks for posting in our Community!

    What you can do is use the LOOKUP function to accomplish this.
    Without seeing the data live, it would unfortuantely not be possible to give a more specific answer, however I hope this pseudo-code helps you!

    Eg, have a seperate series for each client region;

    X-Axis:
    Month from DS2

    Series: 
    IF(
          LOOKUP(Client name from DS2, Client name from DS1, Client region from DS1)="Region X", 
          Employee count from DS2,
          BLANK()
    )

    Then, use an applied group on the X-Axis, and make sure that the output format is set to the month.
          

    Best regards,
    Joshua
    _________________
    Joshua Cohen-Collier,
    Technical Support Specialist, Klipfolio

  • 0
    Avatar
    Gopal Maheshwari

    Thanks Joshua for the same - Will it be possible I can show you quickly Live enviorment , withing 2 mins you can tell issue and i can fix

    Its seems I am doing some small mistake

    Thanks so much for help


    Thanks

  • 0
    Avatar
    Gopal Maheshwari

    Hi Joshua

    - I have done the changes which you mentioned and its has some success but somehow still some data is not plotting on y-axis based on month wise...I am finding the month from date field through substring and then group by

    - Is their any exception handing we need to do?

    Thanks

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Gopal,

    Unfortunately, screen-sharing support is part of a higher package called Ninja Services, which is an account add-on.
    Instead of using the GROUP/GROUPBY functions, I would just use applied grouping instead.

    Hope this helps!

    Joshua

  • 0
    Avatar
    Gopal Maheshwari

    Thanks Joshua - I am able to solve the issues - Its required complex & multiple lookup because of complex JSON

    Thanks

Please sign in to leave a comment.