Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have the following scenario:
fFileInputDelimiter -> tHashOutput
fFileInputDelimiter
id,external_key,name 123,foo123,bar 456,foo456,rab 789,foo789,abc
All of these information I would like to have for later use in the tHashOutput. (Works)
Know I want to have a tSalesforceInput with a query like:
Select id from Account where external_key__c IN (<2nd column of the tFileInputDelmiter>)
So this is a list of Ids and I have no idea how to put them into a list, globalVar or similar in order to use them in my tSalesforceInput.
The query must have the following format:
Select id from Account where external_key__c IN ('foo123','foo456','foo789')
What is the best way to accomplish this?
Best Regards,
udo
Connect your tFileInputDelimited to a tJavaFlex like this one:
Now you can use the global variable (here nammed OBSIds) to build the IN clause:
"SELECT blablabla FROM yourObject WHERE blablabla IN (" + (String)globalMap.get("OBSIds") + ")"