Alteryx Designer Desktop Discussions

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

Removing page break/headers when using text files

kas
8 - Asteroid

Hello,

 

When using a text file in the input tool, I'm wondering if there is any way to remove the headers and page break info that occurs with each page (not including page 1) in the file. (I set it up to not import the first row so the next two rows are the headers)

Below is a sample of the data. The first image is the top of the first page, the second is further down in the data and there are 3 lines (in yellow highlighted area) of the page break info that repeats at each page break.

Hope this explanation makes sense.

 

clipboard_image_0.png

 

clipboard_image_1.png

 

Thanks,

Kim

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Could you use a filter and say [Field_8] does not equal "Page Number"

 

This would take out any rows where page number is in that column.

kas
8 - Asteroid

@BrandonB That's a wonderfully simple solution and works perfectly...thank you!

 

Kim

Labels