Hi,
I have a data set (below) where I want the value in column "Parent ID" to be copied to the column "COL1" if the value in column "MARKER" is "X". So for e.g. "Parent ID" of 1 is marked as X in column "MARKER", I want the "Parent ID" of 1 to be copied to "COL1" next to the "Parent ID" of 2. For clarity, the last table shows what the end result should look like.
MARKER | Parent ID | COL1 | COL2 |
X | 1 | ABC | |
2 | ABC | ||
3 | XYZ | ||
X | 4 | XYZ | |
5 | XYZ |
The End result should look like this:
MARKER | Parent ID | COL1 | COL2 |
X | 1 | ABC | |
2 | 1 | ABC | |
3 | 4 | XYZ | |
X | 4 | XYZ | |
5 | 4 | XYZ |
Thank you for the help! Much appreciated!
Solved! Go to Solution.
Please see below how you can do it based on the explanation :
However I didn't get why you have 4 in COL1 for the Parent ID 3.
Attached the workflow,
Regards,
Thank you both for the replies!