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

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

Sample Data.xlsx

Datasets

Accepted answers

All comments

Qiu

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

0711-Gsiva3.yxmd

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 😄

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335