Based on data on excel sheet how to create new filed

[NiranjanK1]

Hi All,

I have two excel sheets in that one excel sheet have "Show Values", how to create new filed with 0 and 1, 

if show values word found i need to give 1 or else 0, i tried with multi field tool im unable to do it. Please suggest. for reference please have a look at attachment.

Thanks & Regards,

Niranjan

[ShankerV]

Hi @NiranjanK1 

Please find the expected solution.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @NiranjanK1 

Input used:

Please use select tool to modify the column location if it needs to come after Field1.

Many thanks

Shanker V

[NiranjanK1]

@ShankerV Using excel sheet tabs i have to build the logic, that is actually expected output how it looks like. please refer attached excel file.

[ShankerV · Accepted solution]

Hi @NiranjanK1 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[NiranjanK1]

@ShankerV Thank you for your quick answer