Filter common records in Object

Userlevel 3

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

Userlevel 7
Badge +2

@Nalin thank you for sharing your request here.

Userlevel 3

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.