Toggle between two sources

[NidhiAg]

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 ?

[atcodedog05]

Hi @NidhiAg 

You can use union tool for this. To take either of the data to the output anchor. 

Hope this helps 🙂

[Qiu · Accepted solution]

@NidhiAg 

One thought is to union these two sources then filter out the null rows and columns with Cleansing Tool.

[atcodedog05]

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.

Hope this helps 🙂

[NidhiAg]

The two sources has different schema. SO this solution doesnt work for me

[atcodedog05]

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.

[Qiu]

@NidhiAg 

Thank you for the accept mark