We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Eliminating zero's !

T-Dub
7 - Meteor

Hello,

 

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

 

Capture.PNG

 

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!

 

T

 

10 REPLIES 10
T-Dub
7 - Meteor

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

 

Thanks for all your help!

 

Cheers

Labels
Top Solution Authors