Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parse text file which have single line split into next line

VMR
7 - Meteor

Hi -

 

I looking for support to parse a text file with row data splits and comes in the next row. it has to be put back in the same line/upper row. 

 

Example:

VMR_0-1638272393777.png

expectation is highlighted data to be put back to the upper row. Appreciate your help. Attached text file to support better.

1 REPLY 1
grchavarri
11 - Bolide

Hi @VMR 

The quickest way to do so is using the multirow formula but it depends on the parsing that you are doing to the file. 

find attached an image of the example. I have parsed the .txt file as a flat with a fixed width.

 

The formula inside the image:

 

if [Row+1:Field_1]!="" and [Field_1]!=""
then [Row+1:Field_1] else "" endif

 

grchavarri_0-1638274900778.png

 

grchavarri_1-1638274914235.png

Hope it helps,

Let me know with any issues.

Labels
Top Solution Authors