I am reading a data from XLS deleting a column in excel by using “remove data column” and then converting the excel in to .CSV by using “write csv” activity.
While converting “#NA” from excel sheet is converted as -2146826246
Have you tried to loop through the xls file and remove all the #NA before converting it? Maybe if you replace all #NA with blanks or with another value it will work.
@Lucas.Pimentab Thank you I will try it.
Hi tried the above but the problem is I have more that 700 XLS and #NA might appear in different rows and columns.
Can some one help me with it.