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

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.

Input

Accepted answers

mdelaney

@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.

All comments

Henrique10

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

mdelaney

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

ramedfr

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.

xlsb.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703