Join or Union multiple data

[allwynbazil]

Team,

I need to union or join the data from multiple connections(The data from 9 summarize anchors). All the connections have the same columns. However, all the connections will not have data all the time. In this scenario, Union or Join Multiple is not working as expected, and the output is 0. The union or Join Multiple expects the data from all the connections. Is there a way to fix it, or is any other workaround available?

Regards,

Alwin

[binuacs]

@allwynbazil Are you saying the Union tool will not work as expected if some of the summarise tool with no data?

[allwynbazil]

Hi @binuacs ,

Yes. The Union tool works fine if all 9 summarize tools have the data. Otherwise, it is not giving the output.

Regards,

Alwin

[binuacs]

@allwynbazil Union tool should work at least one of the tools has data. Can you screenshot the union output, where it gives you no records?

[allwynbazil]

Screenshot 1. Now I split the summarize tools and connect the first four to one Union, which has data

Screenshot 2. Second four which has no data.

Screenshot 3: The remaining one which has data.

Screenshot 4: Joining all the three to another union which is not giving anything in output.

Regards,

Alwin

[binuacs]

@allwynbazil for the SS-2 which has no data, how the summarise tool is configured? What is the output of those 4 summarized tools if there is no data?

[allwynbazil]

Please check the configuration of Summarize tool below.

If there is no data it has nothing. I mean 0 rows and 0 columns.

Regards,

Alwin

[binuacs]

@allwynbazil That means no data flow from the tools connected before summarize tool (formula tool, append tool etc)

[allwynbazil]

Yes, correct.

Regards,

Alwin

[binuacs]

@allwynbazil, since there are no column names from the summarize tool the union tool, will give nothing. One option I am thinking to create only the column headings if there are no records in the flow. The count record tool gives you the record count and based on that you can create only the headings, try from your side, I will also provide you a sample workflow.