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 ?
@NidhiAg
One thought is to union these two sources then filter out the null rows and columns with Cleansing Tool.
Hi @NidhiAg
You can use union tool for this. To take either of the data to the output anchor.
Hope this helps 🙂
Good catch @Qiu
@NidhiAg If you data sources are having different columns as @Qiu suggested data cleanse tool will be helpful in removing null column (column from the other source). I have updated my workflow on the same.
The two sources has different schema. SO this solution doesnt work for me
Thank you for the accept mark
