Hello, Could someone please assist with this issue. I would like to compare and display the difference between two string columns in two new columns, example: If I had the following two columns: Column1Column2Day: 16 Month: November Year: 2018/2019Day: 16 Month: November Year: 2019/2020 I would like the output to be the following: Column1Column2Difference - Column1Difference - Column2Day: 16 Month: November Year: 2018/2019Day: 16 Month: November Year: 2019/20202018/20192019/2020 Is this possible? Many thanks 3.xlsx

Display differences between 2 string columns

Hello,

Could someone please assist with this issue. I would like to compare and display the difference between two string columns in two new columns, example:

If I had the following two columns:

Column1	Column2
Day: 16 Month: November Year: 2018/2019	Day: 16 Month: November Year: 2019/2020

I would like the output to be the following:

Column1	Column2	Difference - Column1	Difference - Column2
Day: 16 Month: November Year: 2018/2019	Day: 16 Month: November Year: 2019/2020	2018/2019	2019/2020

Is this possible?

Many thanks

3.xlsx

Developer

Accepted answers

Jonathan-Sherman

Hi @HenpetsGordres1,

So i think i've found a way for this to be done:

I've started with the below input (3 records with 3 new lines in each, one for day, one for month and one for year)

The workflow:

And the output for line 1 is just the year, nothing for line 2 (as the values are exactly the same for day, month and year), line 3 the output is the month and year.

Difference - Column1 row 3 output:

Difference - Column2 row 3 output:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200430 - FindDifferencesInStrings.yxzp

All comments

MarqueeCrew

@HenpetsGordres1 ,

A clarifying question for you: The cells contain embedded new lines. Are you requesting that the output include these embedded new lines too? It would seem that you could first modify the input to individual records.

The expected output also looks suspect. While both columns have "Month: November", you want the difference to be the value of year.

If you try the CReW Delta macro: https://gallery.alteryx.com/#!app/CReW-Delta--Alpha-/5b41141b826fd3116445fee8 I think that you'll get your desired results.

Cheers,

Mark

HenpetsGordres1

Hi Mark,

Many thanks for your response, to clarify the attached excel was dummy data to try and simplify my issue. I do need to retain the embedded lines as I am comparing variables within 2 XML documents. I have attempted to use the macro but rather than identifying the actual differences, it gave me the following:

Ideally I would have 2 columns as depicted in my desired outcome. Apologies if I have understood the Macro incorrectly. I'm also not sure what is suspect about the requested output, the difference between the columns is the value which follows "year:"

Many thanks

Jonathan-Sherman

Hi @HenpetsGordres1,

So i think i've found a way for this to be done:

I've started with the below input (3 records with 3 new lines in each, one for day, one for month and one for year)

The workflow:

And the output for line 1 is just the year, nothing for line 2 (as the values are exactly the same for day, month and year), line 3 the output is the month and year.

Difference - Column1 row 3 output:

Difference - Column2 row 3 output:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200430 - FindDifferencesInStrings.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703