Input sheets to Output file

Hi -

I have an input file with Sheet "A". I have to add a Sheet "A" to an already output file in a new sheet. How can I do? any help is appreciated.

ex: Below: Compiled BO input have sheet "A", I have to put that in France CSV output file with a new sheet created as sheet "A".

Topic of Interest

Accepted answers

vizAlter

Spoiler

"France CSV output file"... if it is a "*.csv" file-format, then:

FYI, the "*.csv" file-format does not allow users to add more than one sheet. It's just one kind of Text file-format only.

Hence, you can consolidate your data (using "Union" tool and arrange your columns) then generate the desired output.

FYI, Output tool has only one input anchor so you cannot link more than one tool, however, you can export the consolidated data in multiple sheets of MS Excel file-format.

Export in mulitple Sheets.png

Both Sheets.yxzp

All comments

vizAlter

Spoiler

"France CSV output file"... if it is a "*.csv" file-format, then:

FYI, the "*.csv" file-format does not allow users to add more than one sheet. It's just one kind of Text file-format only.

Hence, you can consolidate your data (using "Union" tool and arrange your columns) then generate the desired output.

FYI, Output tool has only one input anchor so you cannot link more than one tool, however, you can export the consolidated data in multiple sheets of MS Excel file-format.

Export in mulitple Sheets.png

Both Sheets.yxzp

VMR

It worked , thank you so much.

Simple but means a lot as I would create an output with multiple source and sheets. Thanks again!

VMR

Hi @vizAlter,

I tried the way you suggested It worked but the fields /columns are collapsed. I have attached an expected output file with 3 sheets (A, B & C). Can you help me on this to create output as expected? with 3 inputs files with different sheets with different headers. Thanks in advance for your help.

MergeSheetExpected.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703