![External User - Smita Shelke (Customer)](https://community.tableau.com/img/userprofile/default_profile_45_v2.png)
Smita Shelke (Member) asked a question.
Hi Team,
Step 1 - Split the "Column 1" and "Column 2" by using split function
Step 2 - Created calculated filed "Count_Values_Column1" and "Count_Values_Column2"
for Count the number of values (comma separated) in each column
Step 3 - Created calculated filed "Matches_In_Column1" and "Matches_In_Column2"
for Count the number of match values in each column
Matches_In_Column1
(IF NOT ISNULL([Column 1 - Split 1]) AND [Column 1 - Split 1] != '' AND CONTAINS([Column 2], [Column 1 - Split 1]) THEN 1 ELSE 0 END) +
(IF NOT ISNULL([Column 1 - Split 2]) AND [Column 1 - Split 2] != '' AND CONTAINS([Column 2], [Column 1 - Split 2]) THEN 1 ELSE 0 END) +
(IF NOT ISNULL([Column 1 - Split 3]) AND [Column 1 - Split 3] != '' AND CONTAINS([Column 2], [Column 1 - Split 3]) THEN 1 ELSE 0 END)
Matches_In_Column2
(IF NOT ISNULL([Column 2 - Split 1]) AND [Column 2 - Split 1] != '' AND CONTAINS([Column 1], [Column 2 - Split 1]) THEN 1 ELSE 0 END) +
(IF NOT ISNULL([Column 2 - Split 2]) AND [Column 2 - Split 2] != '' AND CONTAINS([Column 1], [Column 2 - Split 2]) THEN 1 ELSE 0 END) +
(IF NOT ISNULL([Column 2 - Split 3]) AND [Column 2 - Split 3] != '' AND CONTAINS([Column 1], [Column 2 - Split 3]) THEN 1 ELSE 0 END)
Note : Matches_In_Column1 and Matches_In_Column2 gives the same value, as we are looking Column each split in another column
Step 4 - Created calculated filed "Match Type"
Match Type
IF [Matches_In_Column1] = 0 THEN 'Not Match'
ELSEIF ([Count_Values_Column1] = [Count_Values_Column2]) AND ([Count_Values_Column1] = [Matches_In_Column1]) THEN 'Full Match'
ELSE 'Partial Match'
END
Problem - If column contains 8-10 values which are comma separated
Is there any alternate way to calculate the Matches instead of splitting the column and doing the comparisons.