How to remove information and rows above table

Question

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.

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.

CharlieS · Accepted Answer

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.