Hi,
How do i read a specific sheet on an XLSB file? I have multiple XLSB files in a directory/folder and what to read a specific sheet from those files in alteryx (eg Sheet Name = "ABC") and output data from all xlsb files in the folder with sheet name ABC in a union.
Is this possible on Alteryx?
Solved! Go to Solution.
Hi @clarrock
Since you know the sheet name, you can configure the Input Data tool to use wild cards "*".
This will read the Dates sheet from all the .xlsb files in the directory. Change "Dates" to what is required.
Dan