GENERATE DATA TABLE - String to Datatable conversion - LOOSING THE ROWS AND EXCEL FILE GETS COPPURTED

Learning Hub
1

Hi Team,

I am in the middle of a module where I want to convert the String into Datatable to write into excel file. 10000+ lines.

Now suppose I have these 12000+ lines with the data separated by 15 “|” signs, making it to be 16 columns.

I am using Generate Data table activity to insert the text file and setting “|” as a separator.

As I get the output of Generate Data table as a DT, I am writing it into the excel file, following are my obsevations:-

  1. Only 5000 lines are outputted into the excel file,

  2. Excel file got corrupted and opens in read only mode.

  3. Looks fine in the Preview of the generate data table

  4. I want to know if there are some limitations for the generate data tables. If not, please help me understand where I am going wrong.

Kindly help, it is urgent.

Thanks and Regards,
@hacky

2

@hacky Can you Check with just 2000 lines if it is possible to create the Excel without any errors while opening?

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.