Split a large file into 20K rows columns

[beatrizmguerreiro]

Hello,

I have a Excel file with two column with more than 200K rows:

1st col: Record ID;

2nd col: Record data.

My goal is to split this main column into smaller columns of 15K rows, in the same workbook.

Until now, I only manage to split it into smaller workbooks.

Can somebody help me? 

Thank you in advance.  

[AngelosPachis]

Hey @beatrizmguerreiro ,

Yes, the simpler way to do this is to add a "Numeric Up Down" tool. Find an example attached 🙂

Was this what you were looking for?

Regards,

Angelos

[atcodedog05]

Hi @beatrizmguerreiro 

yes its possible to use a number up down interface to let user enter the number while running as a app.

[beatrizmguerreiro]

Can you attach a screenshot of the workflow? I can't open the file, because I still have to download the most recent version of Alteryx.

[atcodedog05]

Hi @beatrizmguerreiro 

Here is article for downgrading.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-yxmd-Workflow-yxmc-Ma...

[atcodedog05]

@beatrizmguerreiro 

I have went ahead and downgraded the app for you.