Alteryx designer Discussions

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

Input file formatting & filtering out needed fields

Highlighted
8 - Asteroid

I have a file that doesn't seem to have a delimiter. I'm struggling to break the file apart and/or grab only the fields I absolutely need. Ideally, I only need the tags outlined in red, starting with TU4R and AO01. The problem is every instance starts with TU4R and ends with ENDS01, however not every instance contains a AO01 tag. (See the attached screenshot.)

 

This is how I'd like my final output to be...doesn't need to be exact but close...

Record IDTU IdentifierAO01 Code
1TU4R062011256AO010170705101M00
2TU4R062011259[NULL]
3TU4R062011254AO010170705101M01

 

I've also attached a file with sample data to help come up with a solution. Thank you.

Highlighted
Alteryx Certified Partner

Hi @IJH34, attached is one way you could achieve the output you are looking for. AbhilashR_0-1589991930770.png

Let us know if this doesn't work on your larger dataset.

Highlighted
11 - Bolide

HI, @IJH34 

 

Please mark as an acceptable solution + Like, if this works for you.

 

solution output

RNO2_0-1589992024606.png

 

Workflow

RNO2_1-1589992051222.png

Please see the attachment.

Cheers!

Labels