Dear all,
I have a problem with (else if) when I apply it in the formula,I have as the input file an excel file which contains a column titled by Name and I have several names in this column. I'm applying a formula so that if the name is Sam create a new column by name Sam and put 1 , if the name is Adam do the same and if the name is Adam Sam do the same only put 1 in the column of Adam Sam not other two columns, so any idea on how I can do that?
Thanks in advance for your kind support.
Solved! Go to Solution.
Hi @Feras95p ,
I think, you have to use a different approach. CONTAINS will return "1" for each entry ("Sam" and "Sam Adam" / "Adam" and "Sam Adam"). What about using IF/ELSEIF/ELSE to create a Header/Value pair and the Crosstab tool to move these pairs to rows? Sound confusing, I've attached a sample workflow. Hope it is helpful.
Best,
Roland
Thanks a lot I really appropriate your efforts.
Thanks