How to extract the value in the column+1 based on the value of the column+0

[WilsonZ]

Hi all,

I am working on using the value of column+0 to find the data in column+1. (Modify the input format to required format)

input format:

required format:

Can you help me with it.

Wilson

[jdminton]

Ok, the attached can likely be shortened as I was solving throughout the process, but it does meet your criteria based on the data and should work with additional information. I'm guessing this is coming in as a text file and there might be an easier way starting with the original file, but see attached. Let me know if this works.

[michaelbono16 · Accepted solution]

Hi Wilson, I've attached my solution below. It's very similar to @ jdminton's solution, but I was able to condense much of the logic into one multi-row function. Another note: if you run the workflow with AMP Engine disabled or in Engine Compatibility Mode (accessible from the workflow configuration - runtime settings), the Crosstab tool at the end will automatically sort your data by the RecordID to get it in the correct order. AMP Engine changes the order, but is easily fixable with a sort tool if needed. Hope this helps!

[jdminton]

Thanks @michaelbono16, next time I'll need to go back after another cup of coffee 😂

[WilsonZ]

Thank you both @jdminton and @michaelbono16. The flows perfectly solve my problem.