Remove first few rows using the directory.

Hi guys,

I'm new to Alteryx and I have a problem. I want to remove the first few rows of my excel spreadsheet because the header row starts in the 5th row. I know you can choose where to start the data input if you use the "Input Data" tool, but I'm using the "Directory" tool to retrieve my excel data because the file is password protected. So how can I remove the first few modes while importing data using the "Directory" tool?

Developer

R Tool

Accepted answers

atcodedog05

Hi @davidogundipe

You cannot configure Directory tool. But what you can do is use select to skip first n rows and use dynamic rename to get column name.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Skip rows.yxmd

TheOC

Hi @davidogundipe

As @atcodedog05 has said, this isn't possible within the directory tool, but easily achieveable after the fact. I have done it in this example with the sample tool to skip the first x amount of rows, which is essentially the same as @atcodedog05 's suggestion, just a different way of doing it!

davidogundipe.yxmd

All comments

atcodedog05

Hi @davidogundipe

You cannot configure Directory tool. But what you can do is use select to skip first n rows and use dynamic rename to get column name.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

*Update* it was my mistake, I just didn't properly integrate your solution with my workflow. This worked!! Thanks!

Thank you so much for the help, this solved 90% of my problem. The other part of the problem is that alteryx is still reading the first row as the header row and keep the row. I would like to keep the data from rows 6 until the end, but the 6th row should also be the header row. Rows 1-5 should be completely deleted. I hope this makes sense.

davidogundipe

*Update* it was my mistake, I just didn't properly integrate your solution with my workflow. This worked!! Thanks!

Thank you so much for the help, this solved 90% of my problem. I tried your method and the method recommended by the user above.

The other part of the problem is that alteryx is still reading the first row as the header row and keep the row. I would like to keep the data from rows 6 until the end, but the 6th row should also be the header row. Rows 1-5 should be completely deleted. I hope this makes sense.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703