We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do I delete a summary row and all information after the summary row

mc_ryan
6 - Meteoroid
‎11-21-2022 03:33 PM

My excel spreadsheet has header and footers. I started the data import on line 4, but how do I stop it at the summary row and everything after?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

12 REPLIES 12
Luke_C
17 - Castor
17 - Castor
‎11-22-2022 07:05 AM

Hi @mc_ryan 

 

Use a filter tool on one of the fields with the 'Is Not Empty' option. 

Reply
mc_ryan
6 - Meteoroid
‎11-22-2022 07:09 AM

You're a genius! It worked again, thank you so much!

Reply
Luke_C
17 - Castor
17 - Castor
‎11-22-2022 07:10 AM

@mc_ryan Great! Happy to help

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All