Header Adjustment for XLSB File- Batch Macro Import

[SH_94]

Hi Community,

Currently i had imported the file into Alteryx by using the batch macro. I would like to ask how can i make my source file header as my header in the alteryx. Kindly find the screenshot below for the result shown in the alteryx.

Screenshot as per Alteryx result

Screenshot as per original file

Many thanks in advance

[Emil_Kos]

Hi @SH_94,

Please see the screen below for reference:

[SH_94]

Hi @Emil_Kos ,

Thanks a lot for the prompt response.

I had tried and the result still the same. Kindly refer to the screenshot below for the workflow that i have made.

[Emil_Kos · Accepted solution]

Hi @SH_94,

This is strange. on the screen, you shared it looks like you clicked the left anchor. Can you click the output tool and double-check if the results are the same? 

[SH_94]

Hi @Emil_Kos ,

Thanks a lot for reminding me on the step that i overlooked.

Many thanks.

[Emil_Kos]

Hi @SH_94,

No worries!