Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to remove information and rows above table

Josh5
5 - Atom

How can I remove information in rows above my actual table? Even better, I would like to remove this information, manipulate my table, and then add the rows back once I'm done.

 

Data Before.JPGData After.JPG

 

Here's an example of what I'm trying to do. Is there anyway to do this using Alteryx? Bonus - As said above, if I could add it back at the end that would be great.

 

 

1 REPLY 1
CharlieS
17 - Castor
17 - Castor

Remove it:

- Use a Sample tool set to "Skip first N rows" and set N to 4.

 

Remove and Append later:

- Use a RecordID tool to assign a RecordID field.

- Use a Filter tool set to "[RecordID]>=5" and the T output will have your table of data, F will have the first 4 rows. 

- A Union tool can recombine the records later (night have to be set to Manually Configure if the fields get renamed) 

 

Check out the attached workflow for examples of both.

Labels