0 was unexpectedly added
HI Team,
I’m facing a strange case where 0 was unexpectedly added into data after running CSV reader (same to excel reader or file reader after a few runs)
it didn’t happened to all but only a small portion.
I was trying to create unique Key for lookup and this caused a small group to create wrong key and failed in looking up data.
I can’t simply replace 0 for something else since some of other row also have 0 and need to be used separately
I’m really hoping for your advice on this.
This is the number from Raw data as 12 has no 0
this is the result after executed in CSV reader. 0 was added.