MultiRow Tool

[anom23]

Hello, 

I have the below set of data where I am trying to use the multirow tool to copy data from the order# to receivedcode based on criteria. Essentially if the order starts with IR then IR1 would be copied into the Receivedcode column.  If order# starts with a numerical value (1234 etc), I would copy the data from the Code column.  I have tried several approaches but none seem to work.  Any assistance would be appreciated. 

Example 

RecordID	Order#	ReceivedCode	Account #	code
1	IR1		1234	011111
2	IR2		1234	322222
3	IR3		1234	090909
4	IR4		1234	623344
5	IR5		1234	932332
6	IR6		1234	09408N
7	IR7		1234	08034Z
8	IR8		1234	052021
9	IR9		1234	046575
10	123456		1234	141299
11	456789		1234	755837
12	123456		1234	777550

Desired Outcome

RecordID	Order#	ReceivedCode	Account #	code
1	IR1	IR1	1234	085781
2	IR2	IR2	1234	366856
3	IR3	IR3	1234	09798G
4	IR4	IR4	1234	623344
5	IR5	IR5	1234	934506
6	IR6	IR6	1234	09408G
7	IR7	IR7	1234	08034G
8	IR8	IR8	1234	052021
9	IR9	IR9	1234	046575
10	123456	141299	1234	141299
11	456789	755837	1234	755837
12	123456	777550	1234	777550

[Qiu · Accepted solution]

@anom23 
Hope I understand your intention correctly.

[martinding]

Hi @anom23 

In your case, a formula tool will work.

Please see attached.

 

[binuacs]

@anom23 Similar to @Qiu and @anom23 approach but I used Regex_Match function to check the order# start with numeric value or not?

[ShankerV]

Hi @anom23 

It is possible with Multi row formula tool also.

Here is the possible solution for you.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[anom23]

Thank you all! These solutions worked.