question

arkiboys avatar image
0 Votes"
arkiboys asked KranthiPakala-MSFT commented

build a string for each iteration

what is the best way to pull the companyName fields from a .json file and pass them all in a string like?

... and companyName in ('companyName1', 'companyName2', 'companyName3',...)

At present, inside a dataflow, I get the
1- companyNames into a csv file with one columns
2- in pipeline, using a lookup, I get all the companyNames from the csv
3- inside a foreach activity, iterate through each companyName and process each one individually. For example, rather than building the above string, this is what I do at present:

... and companyName = companyName1
and then process the data retrieved from this string
Then on the next iteration,
... and companyName = companyName2
and then process the data retrieved from this string
Then on the next iteration,
... and companyName = companyName3
...

Question:
How can I build the OR string mentioned above?

Thank you

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hello @arkiboys,

Thanks for the question and using MS Q&A platform.

Similar ask has been answered here in this query - append variable

Hope this helps. Please let us know if the ask is different from the other thread.

Thank you


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you

0 Votes 0 ·

Hi @arkiboys,

If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·