Comapring two files: output formatting assistance

[Empower49]

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!

[MarqueeCrew · Accepted solution]

@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

[Thableaus · Accepted solution]

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,

[MarqueeCrew]

hey @Thableaus,

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

Cheers,

Mark

[Thableaus]

Hi @MarqueeCrew 

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

Cheers,

[Thableaus]

@MarqueeCrew 

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

Cheers,

[Empower49]

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!