Output Data

Hi,

I have two text inputs files in real its an excel file and i m filtering the on FLAG = 1 on both the Data set and i want this to be combined as one excel workbook and each sheet should have its sheet names tried union but the schema is different.

Any suggestions please.

Output.xlsx

Ouptut Data.yxmd

Workflow

Output

Accepted answers

Nick-C

Hi @suby

I've made a quick change to your workflow to ensure the configuration is correct on changing the table name using your sheet name field for both of your output nodes:

Ouptut Data (2).yxmd

All comments

Nick-C

Hi @suby ,

You can do this using a "Block until done" so that it can write to the file for the first sheet and then will write the second sheet on top, make sure you put "Overwrite sheet or Range"

Each of those outputs will be to the same file, just a different sheet name. The block until done allows alteryx to write the first sheet and then only start to write the second once that is done to avoid errors!

Please remember to accept as solution if this helps!

suby

Can you please attach the workflow not getting the expected result by following the steps..

Many Thanks

Nick-C

Hey @suby - Can I check which part isn't working?

Here's my workflow:

Workflow for Suby.yxmd

suby

Hey Nick,

Thanks for your solution but in my case i want to pick the Sheet Name from the Sheet Name column from the Text Inputs since i have huge number of Output to be written and i don't want to go and specify a name manually.

Nick-C

Hi @suby
Ah, sorry - I missed that bit!

You can configure this in the output tool:

Workflow for Suby.yxmd

binu_acs

@suby the below post also having the same use case as yours. The user want to read data from multiple excel files (in which multiple tabs) and combine all in one excel file with different sheets. Attaching the macro also for your reference.

Note: in this case you no need to mention the sheet name , the macro is able to dynamically create the sheet names based on the input file

Solved: Re: Data input - Page 2 - Alteryx Community

ExcelSheets_Combined.yxzp

suby

Hi Binuacs,

Thanks.

In real scenario I'm taking an excel file with multiple sheets with different schema say if have 54 sheets in total i have taken 30 of those sheets and did all the transformation logic and finally I'm overwriting those 30 sheets with my new transformation logic which is fine now.

The place where I'm stuck is say on my 30 sheets i have a FLAG column which holds 0 and 1 and and i have put a filter before the Output Data so that all records with 0 goes on my Output Data and overwrites.

what I'm looking for is on those 30 sheets i want all the records where FLAG =1 and then output those data in single workbook with 30 sheets.

suby

Hi Nick,

I tired your approach

firstly i created a New workbook and call it as sheet 1 and applied the same configuration based on your screen shot and this for stream 1

then for the second stream i pointed the same workbook that was created and called as sheet 2 and applied your configuration based on your screen shot and i'm not getting my expected results.

Thanks

binu_acs

@suby @Can you provide sample excel input files and expected output file

suby

Hi Binuacs,

Thanks i have attached the Expected Output and My workflow.

Where you have the Text Inputs Sheet 1 and Sheet 2 in real these sheets are coming from one workbook for example purpose i have given it as two separate input.

Also where you see the Output Data sheet 1 and sheet 2 is overwritten after my transformations until this I'm fine it works as expected.

What I'm looking for is i want create new Output Data where i want to take the records from the False Anchor on both the streams and create a new workbook and and also with sheet names as mentioned in the expected output excel.

Thanks

Output.xlsx

Ouptut Data.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703