Forum Discussion
Solved
Column Value based upon Cell (parsed)
I am using the folder data connection to bring in multiple excel workbook (specific sheet). Each one needs some basic cleanup but most importantly I need to add a column based upon the value in Row1 ...
Please look at this...
can you share sample data and will get back to you with solution. I got what you want but with sample data it is easy to perfom the steps :)
Im not sure how to upload the actual file but here is a screenshot. I would want to use the value in Column D Row 2, parse out the word Alabama, and create a new column with the word Alabama in it.
Can you share the file using google drive or dropbox
I cannot...my company doesnt allow connection to those. Can you not generate a file quickly? I did that in about 1 minute. Sorry.