Dynamic Input - Starting Row - .xlsb files

Hi everyone, after I installed Access Database Engine 2010, Alteryx did recognize .xlsb files. The issue that I am facing is that I cannot pick the starting row in Dynamic Input tool, as I was doing it with .xlsx files. This is how I see the menu of Data Input after I select the .xlsb.

And this is how I see it when I select an .xlsx file:

Am I missing something or there is another way to do it?

Thanks in advance,

Developer Tools

Dynamic Processing

Accepted answers

All comments

Jean-Balteryx

Hi @JoseMignone ,

I think the option is not available for .xlsb files. What you can do is use a Record ID tool then filter based on this value to remove first rows not needed.

dougperez

Hello @JoseMignone, the xlsb don't have this option... You can use the solution provided by @Jean-Balteryx , or use a sample tool to remove the rows.

Jean-Balteryx

Actually, @dougperez's solution is wayyyy easier, don't know why I didn't thought of it ...

JoseMignone

Thank you both @Jean-Balteryx @dougperez , the problem is that with those tools I understand that I cannot apply the starting row to many files. The reason for me using Dynamic Input with .xlsx was for taking one file as a model and affect every one of them. At least I can discard the possibility thanks to your confirmations.

Jean-Balteryx

Inputting many files, you get a column with file name in your dataset ?

JoseMignone

I made the input with Directory Tool because they are over 120 excel files. I´m not sure if I get you right, but that I could apply it by clicking the following checkbox in Dynamic Input:

Jean-Balteryx

I think using this option with filename you can work out this : use a multi-row formula to add a row ID grouping by filename then filter based on this id ! That way you can remove the same number of rows for all your files.

dougperez

Even easier, use sample with group by option

Jean-Balteryx

And I forgot it again! Hopefully @dougperez saves the day!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703