Hi, I’ve got an issue with regards to the read range activity, my data has only 2 sets of row
but it returns me numerous “empty” data when converted with an output datatable, will return empty commas, does anyone know how I can solve this simply?
I have set the properties of Read Range of Modern Activities to “Display Value” as I need to convert this excel file into a text file with a formatted date.
I’ve resolved it on my own, turns out all you need to do with filter out the excess rows as empty data using the filtering wizard for datatable, set the condition as if empty, to be removed and voila!
Hope anyone that has an issue like me will be able to get it resolved!