Hi please help. What do I do about this error? Thanks!
Hi @CathrinaJay
Kindly change the file output to some other formats such ".csv" or ".yxdb" where possible
Many thanks
Shanker V
It is due to output tool.
Please opt for other data sources than .xlsx when dealing with larger datasets. .csv would solve most issues relating to large dataset.
hello, if I select .csv as the output format what should I put in the configuration panel below?
The default for .csv pick up.
I would recommend to proceed with as is in default for .csv format.
Please find the default .CSV format.
Sample Output:
Please find the output:
Each columns are separated by delimiters.
Here as default ',' is the delimiter used.
If you have , used in your dataset use the delimiter which is unique.
Output:
Kindly let me know if I could help on anything else if struck.
The workflow worked perfectly without error but I cannot open the file it says FILE NOT LOADED COMPLETELY.
Righclick on the output file, Select Openwith and Select Notepad
This will help to open the file. If you are trying to open again in Excel, that might lead to error which you are encountering.
Is it possible to save in excel format with the exceeding rows be saved in the next sheet?
There are many possible solution for your latest question.
Mentioning few below, pick which one works for you based on the data set you have.
Option 1: Use the Record ID tool.
This will create unique record for every row.
Then Split your data's based on the record id where record ID < 1000000
Where filter will have T and F node
T will contain record ID < 1000000
F will contain record ID > 1000000
Output into excel sheet from both T and F node separately
@CathrinaJay
Option 2: Use the Record ID tool.
Use a formula to create groups of 1 million per group (Use tile tool)
Output to your excel file just adjust the tool to create new tabs based on this grouping.
Hope the solution helps!!!!!!
hi can you show me how to configure the formula tool? Here's mine
