-
1. Re: Perform joins using function "contains"
Ken Flerlage Jan 29, 2019 1:43 PM (in response to Vernon Dmonte)It's not clear to me exactly how you want to do the matching. What are the expected results, based on this data set?
-
2. Re: Perform joins using function "contains"
Vernon Dmonte Jan 29, 2019 6:34 PM (in response to Ken Flerlage)thanks for your response ken.
example of the two tables I have is given below:
TABLE 1:
Name
Water connection
Phone
Street address
D Due
No
321543243
PO Box 4259 State Highway 41
A Smith
yes
546543224
Lake Rotoaira Road
Dino Moria
no
546542243
Kepa Road
Table 2:
Name
Title no
Address
Aron Smith
SA1542
PO Box 4259 Lake Rotoaira
Don Due
NA243
PO Box 4259 State Highway 41
MY DESIRED TABLE IS AS BELOW
Name
Title no
Address
Name
Water connection
Phone
Street address
Aron Smith
SA1542
PO Box 4259 Lake Rotoaira
A Smith
yes
546543224
Lake Rotoaira Road
Don Due
NA243
PO Box 4259 State Highway 41
D Due
No
321543243
PO Box 4259 State Highway 41
Dino Moria
no
546542243
Kepa Road
I want to do a full join on partial matches using NAME-NAME and ADDRESS-STREET ADDRESS.
Hope this makes sense. An immediate response would be appreciated as I am on a deadline.
-
3. Re: Perform joins using function "contains"
Denise Delomen Jan 29, 2019 10:17 PM (in response to Vernon Dmonte)Is using blend out of the option?
-
4. Re: Perform joins using function "contains"
Ken Flerlage Jan 30, 2019 7:45 PM (in response to Vernon Dmonte)What you're really after is some sort of fuzzy matching logic, which is not available in Tableau at this time. You're probably going to need to find an ETL/data prep tool that has fuzzy matching built into it, such as Alteryx.