Hello all,
got a little problem here and would be glad to get help.
Using a User Written Code in DI Studio I am trying to UNION 2 datasets to filter out duplicate rows.
Dataset a has 1 column with informat 12.7/outformat 12.7, so has dataset b.
Values are:
dataset a 12.1234594999
dataset b 12.1234595
The value in dataset a is displayed in DI Studio exactly as value b (due to informat/outformat), but once I do not use the usual table view of DI studio, it has all the decimals as written above. So once I do this...
SELECT * from a UNION SELECT * from b
...the values are identified as NOT duplicate.
So there are 2 questions:
- Why does the UNION neglect the in/outformat (do I need to specify the format in the UNION again?)
- How do I round this (round, roundz?) to fit value b so I can round it before the UNION
Any help is appreciated very much.
Thanks,
Thomas