Import Data Using batch marco

[SH_94]

Dear community,

Currently i have the macro built as attached below in order to import all the data one shot into the Alteryx file.

I have two queries as below which would like to clarify:

1. Can we decide which tab of excel file not to be imported into Alteryx? In this case, i actually does not want the tab" Overall" to be imported into alteryx ? Or we only can remove it from the Alteryx after importing it? Can anyone show me on how to remove the certain tab in this case?

   - Reason why i does not want to import it as it consist of more column headers ( i does not need it ) and i not sure it will cause a lot of blank or null column if it combined with other tab of the excel files

2. In the alteryx , i can see some of the column header name as per screenshot below . May i know is it due to extra column in the original file that is empty ?

Thank you so much in advance.

[Luke_C]

Hi @SH_94 

You could add a filter after the first macro to remove this from being processed. See below screenshot. For your second question, yes, this can happen due to some empty cells in excel or stray formatting that makes Alteryx think there is data. 

[SH_94]

Hi @Luke_C ,

Thank you for your prompt response.

For the second question, is there anyway that i can check in alteryx to confirm that there is no data for those column?

As i plan to uncheck those column after importing the data into the Alteryx.

Thank you again for your help.