Eliminating zero's !

Hello,

I am currently working on a tool that looks for differences between two files and that gives a report of said differences.

Currently I have run into a little issue where some files data isn't saved in the same way but have the same values, for instance:

I would like to delete all the useless 0's that are present above.

Here is my progam:

large (1).png

Thanks in advance!

Datasets

Transformation

Data Investigation

Accepted answers

T-Dub

I solved this by adding auto field fucntions to both of the input files.

Thanks for all your help!

Cheers

All comments

Kenda

Hey @T-Dub!

Do you have the CReW macros? There is one called Expect Equal that could be the same thing you're trying to make.

jasperlch

I think what you can do is to add a Select tool on both streams before you do the joining. And then change all the numeric fields to FixedDecimal and size to 19.2.

T-Dub

Hi @BarnesK,

Thanks for your response.

I do not have any additional macros added. Could you tell me where to find or where to get the macros you mentioned?

I'd like to expirement with them.

Best regards,

T-Dub

Hi @Jasperich,

Well the idea seems good, but I think by using this wouldn't 0.00 and 0 still come out as being differences?

Best regards,

Jim7

This formula should work for you (see attached workflow in version 9.1):

ToNumber(REGEX_Replace(ToString([Valeur Fichier 2], 4), "\.\d*([0]+)$",""))

remove unnecessary zeros.yxmd

T-Dub

I solved this by adding auto field fucntions to both of the input files.

Thanks for all your help!

Cheers

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703