Load multiple excel files and remove first N lines for all the Excel 97-2003 format

Hello Team,

I am new to Alteryx and have issue as I want load multiple excel files and wanted to remove first N lines from all the excels. I tried Dynamic input but the option Start loading from line NO is missing as I have excel format as 97-2003. PFA with the sample excel. I want one file with headers as ID, Name and Count.

SampleConcatenate.xls

SampleConcatenate1.xls

Preparation

Accepted answers

All comments

BenMoss

You are on the right track with the dynamic input. The import configurations are set on your template file, all files you then read in will use those properties.

Ben

shreyanshrathod

Hi @ferha_jafri ,

This can be a possible solution. Hope this helps.

Regards,

Shreyansh Rathod

Load multiple excel files (97-2003) format.yxmd

ferha_jafri

With Excel 97-2003 excel format it is not working.

ferha_jafri

Thanks for your reply but still I am not able to get the desired result in real scenario I have 4 excel and in future we can have N no. of excels and in this solution it working for 2 files only, can we a generic solution which will include N no. of files.

Sashikumar

Hi,

I Designed a very simple macro and i think it will resolve your problem.

Spoiler

All_Xls_Files.yxzp

ferha_jafri

Thanks Sashikumar,

I am trying to use you solution for the real data, but not able to change the path of the files, could you please help me to use your solution for my real data. I am new to Alteryx and did not used macros till now.

Thanks in advance

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703