Output Data

[suby]

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.

[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

[Nick-C · Accepted solution]

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: