Hello, Simply what I need is to keep original headers of the data while using union tool. Example: I have: Input1 carstrucksplanes4736 Input 2 Shipboatsubmarines6536 I need: Output carstrucksplanes4736Shipboatsubmarines6536 Note: cars,trucks,planes,ship and ect are NOT DATA , but HEADERS Thanks in advance!

Keep headers while union

Hello,
Simply what I need is to keep original headers of the data while using union tool.
Example:

I have:

Input1

cars	trucks	planes
4	7	36

Input 2

Ship	boat	submarines
6	5	36

I need:

Output

cars	trucks	planes
4	7	36
Ship	boat	submarines
6	5	36

Note: cars,trucks,planes,ship and ect are NOT DATA , but HEADERS

Thanks in advance!

Workflow

Data Investigation

Accepted answers

atcodedog05

Hi @Ilkin

Since above approach doesnt work for you. There is another way.

Workflow:

1. Convert them to report table using table tool.

2. Then union them and output it. This way the tables comes one above other without any other header.

Output:

Note : you might have to configure the table tool to get the desired color formatting.

Hope this helps 🙂

table one above other (1).yxmd

Ouput_report.xlsx

All comments

mbarone

A union stacks data, not headers. It's not intended to do what you're asking. What you could do is in your input tools is check the box "First Row Contains Data". It will push your headers down into a data row, and your headers will become F1, F2, etc. You could then union them like that.

atcodedog05

Hi @Ilkin

Extending on the @mbarone post. Here is an example

1. You need to set the above highlighted option First row contains data so that you get column names also as data.

2. Since we are using First row contains data our column name will be F1,F2... which we do not want on our output. Hence select Skip filed names in output tool like below

Output: (F1,F2 are not outputted)

Hope this helps 🙂

table one above other.yxmd

Hi, checking if there is an alternate to table tool to get the output. i need to over write sheets so cant use the render tool.

I tried duplicating the headers, so the main headers gets dropped in the union but the duplicate headers passes through; however, since my 2nd input has extra columns, this does not work well.

delucaeb

Can somebody answer this question ? DivRK makes a good point.

I literally just want to output essentially multiple 'outputs' (aka side calcs / deriviative tables in my WF) into a singular tab.

jrlindem

@delucaeb - This is an old thread, but guessing you might have a similar need? You could consider a three input union where:

1. Is the first dataset

2. Is the second dataset's headers listed out as if it was a single row of data (must match number of columns)

3. Is the second data where the headers will be dropped

You specify the union order in the union tool.

If this doesn't solve your need, consider opening your own post so that we can drill down more specifically to your need without distracting from this post (since this one is already marked as resolved).

Cheers, -Jay

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703