Alteryx Designer Discussions

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

Suppress trail record on CSV within input tool

8 - Asteroid

Hi,


I am working with an input file that is a basic pipe-delimited CSV file that has a trailer record on it that is the date and # of records.  I know I can remove it using tools after the Input because it is structurally different than the data in the first 2 columns.  However, I was wondering if there was a way to suppress it all in the first tool.  I don't see anything in the tool configuration that jumps out at me, but wanted to see what others are aware of with this that perhaps I am just blind to.

 

Thanks

 

15 - Aurora

@DanielG 
Is it possible for you to convert it to xlsx file?

If yes, then we can specify the range to be imported.

Qiu_0-1610577514030.png

 

8 - Asteroid

Unfortunately it is a CSV coming in from a vendor, so not worth the cost to ask them to switch.  I can drop the trailer in a filter, but was wondering if there was an easy way to do it without the extra tool usage.  2021 resolution is to be more efficient in my workflows.  🙂

Labels