tSalesforceinput to find non matching records

[Jennifer_siders]

Hello,

I have a scenario where from a tSalesforceInput component where i would use a Salesforce Query something similar

• SELECT id, Country FROM Customer WHERE country IN ( France,Germany, Russia, Poland), now they query might return records from say France and Germany only, then the process should pick other country values - Russia and Poland and use them to create new customer records.

I am struggling to find which components and flow would help me to achieve this.

Any advice is appreciated.

Thank you.

J

[manodwhb]

@Jennifer Siders​ , you need to create two separate data sets ? one for France and Germany and other one for Russia and Poland?

if your run the below query you will get all the records for France,Germany, Russia and Poland.

SELECT id, Country FROM Customer WHERE country IN ( France,Germany, Russia, Poland)

Thanks,

Manohar

[Jennifer_siders]

Thanks @Manohar B​ 

No, from the query output, i need to find the missing records. If the query output only shows records from France and Germany, then, the flow should find that there were no records for Russia and Poland.

[manodwhb]

@Jennifer Siders​ , then you need to take the tfixedflowinput to maintain a lookup data like country field with all county values and then from tsalesforceInput you will get the contry and connect to tMap as a Main and tFixedflowInput connect to same tMap as alookup and do the innerjoin on country field and take two outputs and one with inner join and other one with inner join recjects in tMap and for innerjoin reject you create a new filed along with country to say that no records for were no records for Russia and Poland.

Thanks,

Manohar