Unable to implement multi-Row formula in my scneario

Jasdev

Hi,

My scenario is in its basic terms:

if there are 4 rows as:

Jasdev

Jasdev Singh

Jasdev Singh Sachdeva

Jasdev Singh Sachdevaaaa

It should change all 4 of them to Jasdev Singh Sachdevaaaa. Even for the scenario

Logic I am trying to use for them is, if row 2 contains row 1 (complete string, if it is Jasdev R, it shouldnt work) then replace row 1 with row 2. The Expression in multi row formula I have used is created a new column checking and below:

IF CONTAINS([Row+1:Name],[Name])
THEN [Row+1:Name]
ELSE [Name]
ENDIF

Kindly provide some suggestions.

Expression

Accepted answers

OllieClarke

Hi @Jasdev you could try and approach this using the fuzzy match tool in purge mode

This is how I set up the fuzzy matching for the dummy dataset. You will probably need to tweak this to get it closer to what you need. The preprocess step of dealing with addresses I think will be useful for you

There's more information on fuzzy matching here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

This is how the workflow looks:

name group_fuzzy.yxmd

All comments

JoshuaGostick

Hi @Jasdev,

What kind of error or output are you getting?

One common error people have is that they forget to change the Data Type within the Multi-Row Formula to a string data type and to increase the Size so that all the text is displayed.

Multi Row Formula.PNG

Does this solve your issue?

Thanks,

Josh

OllieClarke

Hi @Jasdev here's what I came up with:

name group.yxmd

Jasdev

Thank you for a quick response. I am not getting any error. I have changed the type to V_String with Size 50. I don't think that's the issue but the issue that I am facing is, it is not giving me desired output.

I am not exactly doing it with my name, that was just example but I was doing something else with some address field: The input is column 1 and output is column 2, basically it isnt doing anything just copying column 1 to column 2

1600 CLIFTON RD NE	1600 CLIFTON RD NE
1600 CLIFTON RD NE 24 ROOM 7123	1600 CLIFTON RD NE 24 ROOM 7123
1600 CLIFTON RD NE BLDG 1	1600 CLIFTON RD NE BLDG 1
1600 CLIFTON RD NE BLDG 18	1600 CLIFTON RD NE BLDG 18

Jasdev

Thanks for an alternate approach of not considering multi row formula. I tried using it with a huge production data sets and it looks like it takes forever to run the workflow. It gets stuck at the formula where the "group" variable is computed.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703