Capstone Solution - Record ID filter

[BenMurrells]

Bear in mind that I'm only about 6 months into Alteryx and my knowledge is probably thinner than most.  With that being said, I have a question surrounding the solution to the Capstone exercise.  And maybe I'm getting a bit ahead of myself but isn't filtering out records individually a bit... well... basic?  What if the incoming dataset was 1 million records?  Surely the same solution wouldn't apply.  No doubt I'm getting a bit ahead of myself and there is a much smarter solution to the issue of finding the headers hidden within the data, but I'd be interested to know what that is if anyone could help.  For reference this is the filter I'm mentioning...

[Luke_C]

What's the criteria you're looking to filter on? 

[BenMurrells]

Apologies Luke.  Just to explain further.  I'm actually not looking to filter on the data.  I thought there would be a much smarter way using Alteryx of finding repeat like data which are clearly headers.

However, the exercise attached.  You will see in the first data source "Supplied Survey Data" that the required headers exist...

For example:

Name

Department

Q1

and so on...

To manually remove rows using a filter to get to the position required just seems a little bit basic.

[FinnCharlton]

Hi @BenMurrells, that is definitely a terrible way of doing it, I would approach it by utilising the repeating rows of Header, Value, Header, Value with the multi-row formula tool. You can then join the headers onto the values on record position before transposing it into a good format.

I can't attach screenshots at the moment (for some reason) but have a look at the attached workflow to see what I mean.