Deleting the empty row ( used in Macro)

[SH_94]

Dear community,

Currently i am building a macro to read all the sheets in one excel file. However, different sheet have different spacing as below:

For sheet one, it start at the row 3 

While for sheet two , it start at at the row 6

May i know is it posssible to ask alteryx to read starting from the row that contains "initial data" wording dynmically?

Many thanks in advance. 

[ArtApa · Accepted solution]

Hi @SH_94 - It actually skips empty rows. You can also put a Filter to remove rows you don't need. However, I'm not sure why you need a macro. You file can be read with a Dynamic Input:

[SH_94]

Hi @ArtApa ,

Thank you for the prompt response.

Reason i use macro is i have multiple excel file in different folder and different empty row.

Could you please advise what is the main difference between macro and dynamic input and also how to use them wisely in different situation?

Thank you.

[ArtApa]

Hi @SH_94 - The major difference will be in the ability to read data with different schema. Please have a look at the following article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...  

[binuacs]

@SH_94 The attached workflow created based on your input file and expected output result.