I am pulling multiple .xlsx files in using PQ. One of the columns in the data files is called "Orig Cust Reference" which is formatted as a text, but looks like a decimal.
500.1903
717.71714
2.5
505.3111
When PQ pulls the data in, it is adding what appear to be additional decimal places. The 717.71714 shows 717.717409999999997 and 505.3111 goes to 505.3111000000001
Stepping through the PQ load, the data type is never changed from text.
Any suggestions on how I might resolve this issue?
Thank you.
Hi Jeff,
Welcome to our forum!
Are you able to share the PQ file and source file, or at least an example so I can troubleshoot? One idea...have you tried removing the original 'Change Type' step that gets automatically applied when you import the data the first time? Then format the column as text?
I presume the data in the Excel files is actually text, i.e. you can't add up the cells containing the numbers?
Mynda
