Comapring two files: output formatting assistance

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!

Developer

Preparation

Expression

Accepted answers

MarqueeCrew

@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

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,

Ex.1.yxmd

All comments

MarqueeCrew

@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

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,

Ex.1.yxmd

MarqueeCrew

hey @Thableaus,

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

Cheers,

Mark

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703