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
Page 1 / 1
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.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.