Dynamic Input - Starting Row - .xlsb files

[JoseMignone]

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, 

[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!