community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Comapring two files: output formatting assistance

Highlighted
Asteroid

One of the fabulous Alteryx pros helped me create the following output to show differences in two files:

 

IDEFFDATE1EFFDATE2 RANGE LOW 1 RANGE LOW 2
482312/31/201912/27/2019  
4999  19401920

 

Now it's been requested that the output be formatted as below and I don't know how to populate the "field" column because we created a field 1 (for the first compare file) and field 2 (for the second compare file.)

 

IDFieldValue1Value2
4823EffDate12/31/201912/27/2019
4999Range Low19401920

 

Do the experts have any suggestions? Thank you!

Alteryx Certified Partner
Alteryx Certified Partner

@Empower49 ,

 

Use a CReW macro that I have placed in the public gallery to see differences (side-by-side).  Open the macro to see how it works.

 

CReW Delta

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Empower49 

 

See the this workflow appended.

 

Basically some transposing, RegEX to separate Values (1 and 2), data cleansing and Cross-Tab to put it back together would solve the problem.

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

hey @Thableaus,

 

would you like to try my macro and give me any feedback?

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner
Alteryx Certified Partner

Hi @MarqueeCrew 

 

I had not seen your post before, I'm gonna check it right now and sure, I give you feedback.

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

@MarqueeCrew 

 

Cool macro. I guess this would get @Empower49  straight to the final output he needs in just a single tool.

 

Cheers,

Asteroid

Thank you both VERY much! I learn something new from this community every day. I really appreciate you sharing your expertise - it makes so much sense to me after I see someone else's solution!

Labels