Deleting the empty row ( used in Macro)

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.

Reading starting from the row has the word.xlsx

Common Use Cases

Accepted answers

ArtApa

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:

ReadDataAA.yxmd

All comments

ArtApa

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:

ReadDataAA.yxmd

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.

binu_acs

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

DeletingEmpty_Rows_18_06.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703