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.  

[mceleavey]

Hi @beatrizmguerreiro ,

do you mean in the same spreadsheet split it into different tabs, each containing the same columns but up to a maximum of 15k rows on each? So every 15k rows, create a new tab?

M.

[AngelosPachis · Accepted solution]

Hi @beatrizmguerreiro ,

I have mocked up a workflow that I think answers your question. 

I have created a Column ID for each row and then used the modulo operator to get the desired number of rows (15k)

Let me know if that worked for you or you have any questions

Cheers,

Angelos

[beatrizmguerreiro]

Same spreadsheet, split it into different columns, each containing up to a maximum of 15k rows on each.

[beatrizmguerreiro]

Kind of... 

The split of the columns worked, however I need to keep the headers and cannot add other headers (that happens with "MOD"). 

Is there a way to hide this? 

Thank you very much for your input and help!

[AngelosPachis]

If your output is in an excel file as shown below, then you would just have to tick the "Skip field names" checkbox and that would hide the column headers.

If that answers all your questions, please mark the solution as correct to close this thread

[beatrizmguerreiro]

Also, I noticed that the rows 15000, 30000, ... are not showing up. Is there a solution for this?   

[AngelosPachis · Accepted solution]

Yes @beatrizmguerreiro I just noticed that as well. 

If you don't mind, can you please change the formula for the Column ID to what is shown below:

That should solve it and you will be able to see all rows in your output.

[beatrizmguerreiro]

Perfect! 

Thanks a lot for your help 🙂

[beatrizmguerreiro]

Hey @AngelosPachis !

I trying to add some "complexity" to the workflow.

Is it possible to add an Interface tool to set up the number of rows I want to split my main column?

My goal is that the end user won't need to change the workflow itself, in Alteryx.