One of the fabulous Alteryx pros helped me create the following output to show differences in two files:
ID | EFFDATE1 | EFFDATE2 | RANGE LOW 1 | RANGE LOW 2 |
4823 | 12/31/2019 | 12/27/2019 | ||
4999 | 1940 | 1920 |
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.)
ID | Field | Value1 | Value2 |
4823 | EffDate | 12/31/2019 | 12/27/2019 |
4999 | Range Low | 1940 | 1920 |
Do the experts have any suggestions? Thank you!
Solved! Go to Solution.
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.
Cheers,
Mark
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,
hey @Thableaus,
would you like to try my macro and give me any feedback?
Cheers,
Mark
Hi @MarqueeCrew
I had not seen your post before, I'm gonna check it right now and sure, I give you feedback.
Cheers,
Cool macro. I guess this would get @Empower49 straight to the final output he needs in just a single tool.
Cheers,
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!