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

Alteryx designer Discussions

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

Comapring two files: output formatting assistance

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