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

    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security