In my macro I have a two input source using Dynamic Input(not macro input) and one macro output. And at any time either of two sources will have rows. I need to take only source which has rows and pass it to single macro output
Any suggestion ?
Solved! Go to Solution.
Hi @NidhiAg
You can use union tool for this. To take either of the data to the output anchor.
Hope this helps 🙂
One thought is to union these two sources then filter out the null rows and columns with Cleansing Tool.
The two sources has different schema. SO this solution doesnt work for me
Hi @NidhiAg
Did you try the last response where its using the data cleansing tool. It should be able to handle 2 sources with different schema.
Let me know if it works.
Thank you for the accept mark