I’m trying to read a excel file containing 3 lakh records in it and filtering the data table with some required columns. Then i’m trying to write the filtered table into new sheet. The issue is that , in the actual sheet, Column Name is product ID, my row value is 005300608 which is a string and when i copied the data into new sheet with write range activity, it is converted to 5300608 which is a integer. when i tried to make pivot on that, it is summing up the data in the product ID column as well.
I find a solution mentioned that, for each row , if we append a (’) apostrophe, then the row data will be string. if i want to do that for all 3 lakh records, then the robot will run for 4 hours and there will be no use of automation here.
Can anyone provide me a solution for my issue?
Many thanks in advance.