Labeling Data Based on Source in Final Output

Hi all,

Couldn't find this question on the message boards but hopefully it's pretty simple.

In the workflow I'm creating now, I use various Excel sheets that, at their core, contain similar information. Using various filters/cleansing, I eventually combine them all together into one. That part is working fine. What I'd like to do is on that final combined sheet, include a column that indicates which source file it came from so we can identify volume in each. Is there any way to add a column or formula-driven column that shows what original source sheet a value came from?

Thanks!!

Workflow

Accepted answers

JoshKushner

In the input tool select 'Field Name Only' the dropdown "Output File Name as Field"

All comments

JoshKushner

In the input tool select 'Field Name Only' the dropdown "Output File Name as Field"

MKM

Thanks for the reply JoshKushner!

I tried doing that with all my data sources (there's about 5-6) and re-ran the workflow with a browse at the end. I couldn't find a column with the file names indicated at the end, nor could I find that option to select those as column in any of the "Select" tools I have throughout the workflow. Is there something I need to do to get the column to appear?

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703