Skip to main content
N
Nalin
Contributor ⭐️⭐️⭐️
May 24, 2021
Question

Filter common records in Object

  • May 24, 2021
  • 2 replies
  • 42 views

Consider Below Tables, I have a requirement to extract details from Usage Details Table where account ID doesn't exists in Account Table. How can I achieve this?

 

The output should only provide details from Account ID 12 from Usage Details Table

 

    2 replies

    sai_ram
    sai_ram
    Expert ⭐️⭐️
    May 24, 2021

    @Nalin thank you for sharing your request here.

    W
    Wayne
    Expert ⭐️
    May 24, 2021

    You can achieve it by building a rule or data designer where you fetch from both data sets and then merge on that id.

     

    Full steps,

    Account table Fetch A and usage details fetch B.

    Merge A with B retaining all records from B merging on account id field.

    Transformation, case statement output boolean, label Blank. If account id from fetch A, after the merge, is null then output True, else false.

    Second transformation, filter out where the blank filed = false.

      Terms & ConditionsAccessibility statement