Union Tool is not Working on Blank Data

[Rhaldhar]

Hi Team,

I am having a data where using filter with dynamic rename and then doing union. PC data filter is not available in this file however, there can have PC data in another file, so will not remove filter for same. however, while doing this process the union tool is not giving the output.

Please help to resolve the issue.

I am attaching the WF.

Thanks in advance.

Thanks,

Rajeev

[alexnajm · Accepted solution]

It's because the Dynamic Rename on no data is basically giving no columns, so it doesn't know how to Union the first two stream with the last one. Try this solution! It utilizes a Batch Macro to complete this.

[Rhaldhar]

Thank you so much. It works.

[alexnajm]

Great news!