Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
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: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Tab Delimited Text File Parsing

acmarsh
5 - Atom
‎08-18-2023 01:25 PM

I have a tab delimited ,txt file with 11 rows of header, 12th row has column headings, and then 100k + rows of data in the body. 

 

How can I grab/store off the first 11 rows somewhere and then do what I want to rows 12-100k and then output the first 11 rows to Excel followed by the parsed 100k+ rows of data?

 

Is it possible to insert another row at the end with an Excel formula to subtotal all the rows?

 

Thanks!

Labels:
Reply
0 Likes
1 REPLY 1
rzdodson
12 - Quasar
‎08-18-2023 02:47 PM

@acmarsh I can definitely help you out here. When able, can you provide a dummy set of data?

Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels