How to use the FindString function with a column name as parameter?

GraceK_dup_114

Hi everyone!! 

I have a dataset with a first column named "full path" that contains string elements. I have 68 others columns names "LI00A1", "LA00B4", "LI01A8", etc...that are all empty columns. I would like to fill those empty columns by saying to alteryx for each line of those columns : if [full path] contains the name of my column, then give me its position in the string (FindString), if not give me nothing (or -1 as it already does, whatever), and reply this formula on the next 68 columns. Does anybobody have an idea? 

For example : for filling my column "LI00A1", I want to say to alteryx FindString([Full path],"LI00A1"). But, as each 68 column names are differents, I don't want to have to type 68 different formulas for each column, but instead I would like to find a way of replacing "LI00A1" by a colum name parameter, and to say to alteryx to replicate this formula for the 68 columns. I hope it's pretty clear... 

Thanks in advance,

Grace

afv2688

But were the new colums created? Are they also empty

If you want your columns to be replaced you have to uncheck the 'Copy output Fields Add' and the 'Change output Type to' ->String Or Double

cheers