Alteryx Designer Desktop Discussions

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

Removing rows from Excel worksheet and adding them to a new worksheet

Travis_Ratliff
8 - Asteroid

Hello All,

 

I have an excel worksheet that looks like this:

Travis_Ratliff_0-1666119017816.png

 

What I would like to do is take everything including that dashed line and put it on another worksheet in the same spreadsheet and label it "Tractions Error Log"

 

Any help would be appreciated on this

 

3 REPLIES 3
acarter881
12 - Quasar

Hello @Travis_Ratliff.

 

This can be done as shown in the spoiler. I've attached the workflow. Please try it with your data and let me know if it works.

Spoiler
acarter881_0-1666121290913.png

 

 

Travis_Ratliff
8 - Asteroid

@acarter881 This worked but I was wondering if you knew how I could do it and get rid of the headers up top on that page?

acarter881
12 - Quasar

@Travis_Ratliff Yes, that's a good point / question (see screenshot below).

 

acarter881_0-1666132780092.png

 

Labels