Delete specific top rows based on condition

I have multiple data sets in the same format as the snippet below, except the number of rows between those with column headers varies. I am trying to make the second set of column headers (AFP CODE, DESCRIPTION, etc) the first row of all my data sets. I have been attempting to Union all data sets together, then use a multi-row formula, but it is not working. Can someone help me come up with a solution?

Apologies , I am very new to Alteryx!

Workflow

Tips and Tricks

Expression

Accepted answers

BrandonB

I like to take this approach where the headers can be dynamically identified no matter what row they start on. In your case you know that AFP code is where the data starts. Please take a look at the attached workflow and let me know if this helps!

Dynamic Headers.png

Dynamic Headers.yxmd

All comments

fmvizcaino

Hi @mattpeltcfa ,

One option is to change the line you start importing your file in the input data tool.

But if that is not an option for you, I'm attaching an example to show how you can use the header as you want, but this example only work for one file per time only.

Let me know if this works for you.

Best,

Fernando Vizcaino

2020-01-23 Delete specific top rows based on condition.yxmd

BrandonB

Dynamic Headers.png

Dynamic Headers.yxmd

mattpeltcfa

That worked! Thank you!

munchkin100

@BrandonB this is exactly what I was looking for as well. Thank you @mattpeltcfa for this question and @BrandonB for your answer.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703