Copy selected data from the sheet to a new excel sheet

Hello Friends,

I need your help. I want to copy the first table to a new excel sheet. As per the attached file I want to copy data from the first table but not from the below table. All the table header marked in yellow color. How to design this in Alteryx? Please help. It should be dynamic. First able might have 45 rows but it can be more or less than that.

Book1.xlsx

Workflow

Accepted answers

IraWatt

Hey @ArijitRoy,

Here is one approch:

you can use a multi row formula tool to identify each table then filter off each one you want.

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

All comments

Sebastiaandb

@ArijitRoy ,

Here you go, this should help you :-).

I made two possible outputs for you .

Basically you give the Excel table in Excel a named range and load the named range into Alteryx. In that way the table can become bigger without you having to worry about not getting all rows.