If you want to get data from excel sheet, can you try ForEachExcelRow activity instead of GenerateDataTableFromText, as the following image?
hi Yoichi. thanks for your reply. the idea is to extract data from text file converting into excel version, and will need to fixed width column and the change the format of each data in excel column. i’ve tried below method. it can be work for 1 file (2652kb). i tried with another file which the file size bigger (244922kb), but this job stopped with unexpected error.
i would appreciate if you willing to share idea to solve this problem
I think 240MB text file is too large to process using GenerateDataTable etc at once in UiPath. If we use Studio(not X), we can handle it line by line. However, it might be difficult in StudioX.
Or if you can split it in advance, it might work.
Could you advise, on what method to use if let say i want to split the text generated into few smaller files? As i am still really new with automation uipath studio X… i will need some guidance on how to know which function to be use.
Unfortunately, I don’t have very good idea for now. If you can use some file split application, StudioX might be able to handle it.