Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
alteryx Community

# Alteryx Designer Desktop Discussions

SOLVED

## MultiRow Tool

7 - Meteor

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
5 REPLIES 5
20 - Arcturus

@anom23
Hope I understand your intention correctly.

13 - Pulsar

Hi @anom23

In your case, a formula tool will work.

19 - Altair

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

17 - Castor

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

7 - Meteor

Thank you all! These solutions worked.

Labels