If else conditions

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.

Sample.yxmd

Workflow

Udacity

Accepted answers

echuong1

I believe the functionality you're looking for can be achieved with a cross-tab tool.

I'd add a formula tool just to set a value of 1, so when you use the cross-tab tool you can get a count of each name instance with the aggregation.

New Workflow3.yxmd

All comments

RolandSchubert

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

Sample_modified.yxmd

echuong1

I believe the functionality you're looking for can be achieved with a cross-tab tool.

I'd add a formula tool just to set a value of 1, so when you use the cross-tab tool you can get a count of each name instance with the aggregation.

New Workflow3.yxmd

Feras95p

Thanks a lot I really appropriate your efforts.

Feras95p

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703