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!!
Solved! Go to Solution.
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!