value comparision
1 Topic
splitting string by delimiter and comparing the results for mismatch values
Hi All, I have a dataset containing two string columns(Region names). The values are combined with a delimiter ; I need a distinct count of rows that have a mismatch between RegionA and RegionB for a date. I will need to use the measure in a table to show the count of mismatch rows (values not matching or when there is null) when Agency = "Yes". From the below example, For 11/1/2024, the total should be 2(345 is not counted as Agency = No), for 11/8/2024 the total will be 1 Thanks in advance for your time and help. Date ColumnA Agency RegionA RegionB Mismatch 11/1/2024 123 Yes Phoenix;Charlotte Phoenix 1 11/8/2024 123 Yes Phoenix;Charlotte Phoenix;Charlotte 0 11/1/2024 345 No Edison;Atlanta 1 11/1/2024 567 Yes Tampa;Raleigh 1 11/8/2024 345 Yes Edison;Atlanta Edison 1 11/8/2024 567 Yes Tampa;Raleigh Tampa;Raleigh 0Solved1.8KViews0likes11Comments