Alteryx Designer

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

Selecting a row to start data import from a .xlsb file

Highlighted
7 - Meteor

Hi all,

 

I need to use a .xlsb file as an input from row 3 to the end of the file. Column labels are at row 3 and the actual data start at row 4.

 

Unfortunately there isn't a "Start Data Import on line" for .xlsb files as it is there for .xlsx files.

 

I learnt that I could use the Select Records tool to specify the rows I want to use, but it didn't work. After witting +3 in Ranges field, Alteryx keeps getting data from the very first row.

 

Any thoughts?

Thank you.

Highlighted
5 - Atom

Hello, Try to put a filter that contains the labels on line 3.

Highlighted
7 - Meteor

Hi @ramedfr - I would recommend bringing in all of the records from the xlsb file, and then you can simply add a Sample tool to skip the first 2 rows, and a Dynamic Rename tool to take field names from first row of data (it is an option on the Rename Mode dropdown). That will accomplish the same task as what you can do with xlsx files via the Input tool.

 

Hope that helps.

 

Matt 

Highlighted
7 - Meteor

Hi @mdelaney,

 

This didn't work. I selected "Skip 1st N rows" and set N = 2 in the Sample Tool. If a put a Filter tool after that, the columns values I see aren't the ones on row 3. Alteryx keeps showing columns as if I didn't use the Sample tool.

 

I'm attaching a picture of the values I see in the input tab when I click on the Sample tool.

 

Thank you.

 

 

 

Highlighted
7 - Meteor

@ramedfr Thanks for including the picture. If that is what you are seeing in the input side of the Sample Tool, then you only need to skip 1 row of data (set N = 1), as it looks like the headers are on Record 2. You will then need to add the Dynamic Rename tool after the Sample tool to take the field names from first row of data.

 

Then you can add a Filter tool after the Dynamic Rename tool, and it should show you the correct column headers.

Highlighted
7 - Meteor

This worked fine. Thank you!

Labels