Splitting delimited values into multiple rows

Splitting delimited values into multiple rows

Hello, 

I'll try to briefly explain the problem I am facing in Zoho Analytics. 
So, I created several forms in Zoho Forms, integrated it with Zoho CRM and then created a module in Zoho Analytics to receive the filled data. 

Let's say I have three columns in CRM: Crop, Region, Municipality.
In Forms the Municipality column is checkbox. Therefore in case the respondent will check several municipalities for 1 crop and 1 region, in CRM and Analytics I receive the Municipality column with delimited values. 


CROP
REGION
MUNICIPALITY
Almond
Kakheti
Telavi, Kvareli
Blueberry
Adjara
Keda, Batumi

Then I split a Municipality column and wrote a query so I receive a totally new table with multiple rows. However, when I am trying to JOIN the new (only municipality table) with the second table, I receive duplicated, or wrong data. Can you please assist with this issue because maybe I'm not joining it correctly? 

I want to get one table with the following result: 

CROP
REGION
MUNICIPALITY
Almond
Kakheti
Telavi
Almond
Kakheti
Kvareli
Blueberry
Adjara
Keda
Blueberry
Adjara
Batumi

I also tried to use split_string function, but it tells that zoho doesn't support this statement. The same was when i tried to create a function. 


Thanks in advance. 
Best Regards, 
Tekle