Maintain excel tab name in the output

[lelecardozo]

Hello everyone,

i have 2 separated inputs for this file, which is working fine, but i want to add a column reflecting the tab name taken from the excel input.

So the last column (Tab name) should look like something like this:

STATE	Party_Id	Subfile date audit	Compliance Id	Add_remove sheet date audit	In subfile	Same Date Audit	Tab name
ERISAPWC	8d4be98c-a17a-4f3e-ae47-481312657291		2	7/1/2020	Yes	No	AddRemoveJurisdiction 11132023
GAOCPA	4331af82-e2e6-4c58-9c91-7d9703727c07	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	78a421c6-c754-4963-824a-2d7b22992c40	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	79a5f774-e9d1-422e-a59e-a76853ecaa6f	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	d17efb67-c4b0-402b-9290-7c83ab7e9ea1	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	f4c4e8af-bb3b-4de1-a020-78821bae92a8	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	f92c9431-a07f-4058-a666-dd75c6b16c02	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023
GAOCPA	ff683926-dfd4-4f13-b76a-37e01ccccb3a	7/1/2021	4	7/1/2021	Yes	Yes	AddRemoveJurisdiction 11152023

Hope i explained my self correctly,

Thank you,

[JosephSerpis]

Hi @lelecardozo you have the option in each of your Input data tools to output the filename as a field this in the configuration window of the Input data tool. You will need to the parse the sheet name if that is only information you need from the filepath however that should be reltively easy as the sheet name usually has ||| before it so a Text to columns tools should suffice.

[lelecardozo]

So when i try to set both "output file name as field" to either File name only or Full path

I lose the information gathered from the second conteiner (GAO) (no error pops up)

also, where should i put the Text to columns tool? i tried next to the input, and i couldnt filter by |||

[JosephSerpis]

Hi @lelecardozo you can put a text to column tool wherever you want in your workflow try | instead on the file name. Selecting the option should not stop your data running correctly. However you have not included your data in your workflow that you attached so cannot mock up a example in your flow. You need to export your workflow as a Alteryx package (Options - Export Workflow). However make sure you only include mock data and never any real data on the Alteryx community.

[lelecardozo]

I have attached the WF package, thank you for all the help!

[binuacs]

@lelecardozo added the tab name in your workflow, you need to add a filter tool and remove all the unwanted rows from your final output