Data comparison between multiple fields

[NiranjanK1]

Hi All,

i have below data how can i compare data and give true-ups. what is the best way to do the comparisons in Alteryx.
when i read article they are using Fuzzy Match. what are the other ways we can compare multiple columns.

Input

Num

EDate

P Date

T Date

S Date

Rate

Cost

S Cost

D Rate

22931

10/4/2022

10/6/2022

10/04/2022

10/06/2022

1

71000

-71,000.00

1.0

100784

10/4/2022

10/19/2022

10/04/2022

10/20/2022

0.9

1139700

-1,139,700.00

0.9

39107

10/4/2022

10/6/2022

10/04/2022

10/06/2022

1

3700

-3,700.00

1.0

280749

10/4/2022

10/19/2022

10/04/2022

10/20/2022

0.9

125100

-125,100.00

0.9

Expected Output

Num

EDate

T Date

Comp

P Date

S Date

Comp

Rate

D Rate

Comp

Cost

S Cost

Comp

22931

10/4/2022

10/04/2022

TRUE

10/6/2022

10/06/2022

TRUE

1

1.0

TRUE

71000

-71,000.00

TRUE

100784

10/4/2022

10/04/2022

TRUE

10/19/2022

10/20/2022

TRUE

0.9

0.9

TRUE

1139700

-1,139,700.00

TRUE

39107

10/4/2022

10/04/2022

TRUE

10/6/2022

10/06/2022

TRUE

1

1.0

TRUE

3700

-3,700.00

TRUE

280749

10/4/2022

10/04/2022

TRUE

10/19/2022

10/20/2022

TRUE

0.9

0.9

TRUE

125100

-125,100.00

TRUE

Thanks in Advance,
NR

[OllieClarke · Accepted solution]

Hi @NiranjanK1 

I've tried to intuit your rules of comparison, although I'm a bit confused by 10/19/2022 and 10/20/2022 being the same

I don't think you want to fuzzy match here - you can write your rules in a formula tool like so:

Then it's a relatively straightfoward workflow

[NiranjanK1]

@OllieClarke Thank you so much for your response, in which scenario will use fuzzy match. 

[OllieClarke]

@NiranjanK1 fuzzy match is where you have text data which is almost the same and you want to either unify or compare them. 

There's a lot of resources dedicated to it on the community, but I recommend checking out the tool mastery blog on it to start: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485