pass multiple keycolumns to dataflow to use in join

Question

Hello,
At present I have a dataflow which looks at the KeyColumn (Passed in dynamically) and uses that inside the Exists and join transformations...
The parameter setting example of the dataflow is as follows where the dfpKeyColumn is a string:
dfpKeyColumn-----string-------"DepartmentID"

In the dataflow, Inside a derivedcolumn, I get the value of the KeyColumn from source as follows:
JoinFieldSource toInteger(byName($dfpKeyColumn))

Then in another derivedcolumn, I get the value of the KeyColumn from target as follows
JoinFieldTarget toInteger(byName($dfpKeyColumn))

Then in Exists transformation, I do the following
doesn't exist
JoinFieldSource == JoinFieldTarget

Hope you see what I am doing...

All good so far.

Now I would like to be able to use multiple keycolumns rather than one in the dataflow parameter.
i.e. "DepartmentID, ProductID"
Questions:
1-in the parameter of the dataflow, do I use string[] rather than just string?
2- In the dataflow derived columns, to get JoinFieldSource or JoinFieldTarget, what do I do?
3- an example is appreciated.

Thank you

Answer 1

Hello @arkiboys ,
Thanks for the ask and using Microsoft Q&A platform .

Yes you can pass the parameters in an array .

['EMPLOYEEID','LASTNAME']

]2

In the exist transform we can use something like .

In the derived column , you can use something like .

Please do let me know how it goes .
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators