hi I need to create a calender to upload into our ERP(business central)
the file is about 90.000 customers I’ve added the holidays and weekends as non working days. I already created a loop to make an excel per Company but still I have about 1.225.250 lijnen per company, these I cannot write them to execl.
Is there a way to solve this? I tried to split up the data but I cannot change the file name. ex: COMPANY V1 COMPANY V2
Can you try wiring to another format, e.g. Knime Table, Parquet?
1 Like
@cinthy Excel is not a good format to store large files but there are alternatives
You should be able to edit as part of the file name and add a company name.
1 Like