October 24, 2019
I decided to come here for some help, as I am tired of thinking how this is happening...
Have designed a query that converts some data from the tab Combined, with LE info helps, to the final output on tab SAP TXT, than then manually save as txt, and it used for some data transmission that system requires to be in that specific format.
My question, is for data on combined tab, there are prices that contains more than 2 decimals on column K, have marked in yellow those ones, I need to obtain the output with only 2, as you can see on SAP TXT tab, however for 2 of 4 my steps are not working... while it does work for 2 instances..
Would you know why? only for 1, what shall I do to improve my query and get the output nicer?
I am attaching the excel file, but let me know if I would need to add any snapshot or code here too.
Looks too big, 5MB, so I am just sharing a link to its download, but again, if you prefer I send any snapshot, please let me know
Many thanks in advance,
July 16, 2010
Hi and welcome to our forum,
It appears that numbers where the 3rd value after the decimal is a 5 e.g. 207.775 have a zero appended when split by delimiter. It's a bug, but the workaround is to insert a step: Transform tab > Extract > the first 2 characters.