Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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