Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing the data

jmedidi
8 - Asteroid

Trying to get the below to work. Need to filter the numbers as i have records without the row numbers.

 

ExistingField   
 1   
 Date   
 15-Oct-20   
 2   
 Notes Reference   
 3   
 Engineer's Name   
 dummy@gmail.com   
 4   
 Hardware part number(s) (See note 1)   
 XX-FFF-FFFF   
Expected Output    
     
 DateNotes ReferenceEngineer's NameHardware part number(s) (See note 1)
 15-Oct-20 dummy@gmail.comXX-FFF-FFFF
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @jmedidi 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1632498775856.png

 

Hope this helps : )

Labels
Top Solution Authors