I Have a column named A with values like 0,1,2,3,4 and I have a column named B with values like AAAAA,BBBBB. So much desired output is the the 1st string in column B should get 1st string from Column A and 2nd string in Column B should get 2nd string from Column A.
Can you please help me on this.
Input | Output | ||||
A | B | A | B | Result | |
0,1,2,3,4,5,A,B,C,D,Z | AAAAA,BBBBB | 0,1,2,3,4,5,A,B,C,D,Z | AAAAA | 0 | |
0,1,2,3,4,5,A,B,C,D,Z | BBBBB | 1 |
@Gsiva3
Can not be sure without seeing your real data, but just give a try.
Thanks @Qiu
I hope you have got the result column by subtracting the record ID column, but the requirement is I need the value from Column A to the Result column
@Gsiva3
I only use the RecordID number as an index to retrieve the value from Column A, if you check my workflow. 😁
Hi @Qiu
But I need the Value from Column A to be popualted to Results Column,
Say for example if Column A has "A,Z,C,D" then the result column should have "A" & "Z" respectively.
Please find the sample data below.
Input | |
A | B |
Z,CD,0,1,W,R | AAAAA,BBBBB |
Output | ||
A | B | Result |
Z,CD,0,1,W,R | AAAAA | Z |
Z,CD,0,1,W,R | BBBBB | C |
Why just test the workflow with your new data? ☹️
it seems to be working to me...
Hi @Qiu
I am not able to open your Alteryx workflow looks like you are using the latest version. Can you send me the openable workflow?
It's just a simple formula try to type in which also help understanding 😄