Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to split data into two excel tab

Learner09
8 - Asteroid

Hello All,

 

I have a large data with around 4lac rows and I wanted to split the output into 2  or 3 tabs so that I can get a Total of 4lac rows into 1 Excel file. Could anyone help me in designing the flow for the same.

4 REPLIES 4
ArnaldoSandoval
12 - Quasar

Hi @Learner09 

 

The attached Workflow input an Excel file named Input File.xlsx; its first column is named Entity, the workflow generates one Excel file per Entity value, and the excel file Output_File.xlsx where each entity is a tab in the Excel file.

 

Hope this helps,

Arnaldo

 

Learner09
8 - Asteroid

@ArnaldoSandoval thank you for the flow, but it is not solving what I am looking. Let me describe what I am looking for - I have a large Excel file (as input), which has around 4,25,000 data lines, when I run the alteryx and try to generate output - it shows up the error, "output to large", so I wanted a alteryx flow that split the data into two tabs like 4,10,000 in one tab and 4,15,000 in second in the 1 excel output file.

BS_THE_ANALYST
14 - Magnetar

@Learner09 Easy problem to solve. Something like, add a RecordID (i.e. a row id). Then formula tool to divide the workflow up into chunks. 

I'll provide you with a workflow to meet your needs. I'm putting 1,000,000 rows in each tab. Just keep it capped at 1,000,000 (excel won't permit more than 1,048,576). The excel sheet will be slow to open of course lol 

 

Screenshot 2023-07-07 175324.png

 

 

ArnaldoSandoval
12 - Quasar

Hi @Learner09 

 

I extended the workflow shared earlier by implementing data slicing where the data is sliced by chunk of records, the number of records per chunk is define at the Workflow's configuration tab, I name the field [TabSize] here you define the size of each section as required by your problem.

 

Solution-01.png

 

I renamed the workflow to Excel_Output_Patterns as this is the function it is performing; it generates the Multi_Sheets.xlsx; Multi_Sections.xlsx and the single Excel files.

 

hth

Arnaldo

Labels