Data Modification Needed

r4upadhye

Hi,

Im having some challenge in modifying my data. Half-baked workflow is attached too, pls can you walk me through the last steps?

Input:

Expected Output:

so far i see wrong numbers in the last tool, which is why i cannot understand why it can't do a simple look-up

thanks in advance.

rahul

test.yxmd

gnans19

Hi @r4upadhye, @MarqueeCrew

Another approach using string concat. Attached workflow.

test_gnans.yxmd