How to replace value from One cell to Antoher based on Conditions

[Gsiva3]

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

[Qiu]

@Gsiva3 
Can not be sure without seeing your real data, but just give a try.

[Gsiva3]

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

[Qiu]

@Gsiva3 
I only use the RecordID number as an index to retrieve the value from Column A, if you check my workflow. 😁

[Gsiva3]

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.

[Gsiva3]

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

[Qiu]

Why just test the workflow with your new data? ☹️
it seems to be working to me...

[Gsiva3]

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?

[Qiu]

It's just a simple formula try to type in which also help understanding 😄