This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
@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.