Maintain excel tab name in the output

Question

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:

STATEParty_IdSubfile date auditCompliance IdAdd_remove sheet date auditIn subfileSame Date AuditTab nameERISAPWC8d4be98c-a17a-4f3e-ae47-481312657291 27/1/2020YesNoAddRemoveJurisdiction 11132023GAOCPA4331af82-e2e6-4c58-9c91-7d9703727c077/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPA78a421c6-c754-4963-824a-2d7b22992c407/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPA79a5f774-e9d1-422e-a59e-a76853ecaa6f7/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPAd17efb67-c4b0-402b-9290-7c83ab7e9ea17/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPAf4c4e8af-bb3b-4de1-a020-78821bae92a87/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPAf92c9431-a07f-4058-a666-dd75c6b16c027/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023GAOCPAff683926-dfd4-4f13-b76a-37e01ccccb3a7/1/202147/1/2021YesYesAddRemoveJurisdiction 11152023

Hope i explained my self correctly,

Thank you,

Sub file wf 0.3.yxmd

binu_acs · Answer

@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

Sub file wf 0.3 - Copy.yxzp

lelecardozo · Answer

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

mock wf.yxzp

JosephSerpis · Answer

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.