Join or Union multiple data

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

Join

Accepted answers

allwynbazil

@binu_acs Union at least requires the column headers to join the data. I found the area in the workflow where there is no data and inject the dummy columns to resolve the issue. It works fine now. Appreciate your support.

All comments

binu_acs

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

allwynbazil

Hi @binu_acs ,

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

Regards,

Alwin

binu_acs

@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

binu_acs

@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

binu_acs

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

allwynbazil

Yes, correct.

Regards,

Alwin

binu_acs

@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.

binu_acs

@allwynbazil I was testing your scenario and I found that even though there are no records the summarise tool returns with headings, because of that the union tool is not failing. In your case what is happening? are you passing a blank file without a heading?

allwynbazil

@binu_acs Thanks for checking. I am still trying various ways and have not yet fixed the issue. Since there is no data, there will be no heading as well. I am trying with Generate Rows tool and will update you soon.

Regards,

Alwin

binu_acs

@allwynbazil can you share some sample input similar to the files you are using as input to your workflow, the one with data and the other with no data

allwynbazil

binu_acs

@allwynbazil great!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703