This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Discussions

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

Suppress trail record on CSV within input tool

DanielG
8 - Asteroid
Wednesday

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

 

Reply
0 Likes
Qiu
15 - Aurora
Wednesday

@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

 

Reply
DanielG
8 - Asteroid
Wednesday

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.  🙂

Reply
Labels