# Split function not working when canvas is created

**URL:** <https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899>\
**Category:** Kibana\
**Created:** [March 14, 2025, 8:44am UTC](https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899 "2025-03-14T08:44:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JensHaglof](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@JensHaglof](https://discuss.elastic.co/u/JensHaglof)\
**Post date:** [March 14, 2025, 8:44am UTC](https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899/1 "2025-03-14T08:44:21Z")

</div>

**Hi everyone!**

I'm experiencing a strange issue.

We have data coming into **Elastic** as a CSV file, delimited by semicolons.

When I create a table in **Canvas** , some rows contain data from another column. Additionally, in one of the columns, those rows include data from multiple columns, with the delimiters still intact.

However, when I check **Discover** , that column only contains a single type of data.

### **Example (Fake Data)**

 ![Kibana error example](https://us1.discourse-cdn.com/elastic/original/3X/2/b/2b3a09fa4cf24baa6c9d30a2b5a75aeee93c2249.png)

If I check **"No. of items"** in **Discover** , it only shows integers.

In the CSV file, each column contains only one type of data, as it should. It's as if the split function that separates the CSV data into columns didn't fully work for some rows..

Anyone who knows what might be wrong?  
/Jens

---

<div class="post-metadata">

**Author:** ![JensHaglof](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@JensHaglof](https://discuss.elastic.co/u/JensHaglof)\
**Post date:** [March 17, 2025, 1:45pm UTC](https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899/2 "2025-03-17T13:45:23Z")

</div>

Anyone?

Do you know what the problem might be? Or do you know someone I can reach out to? It seems like a bug in Canvas, but I'm not sure.

I might add that the code is super simple. Just a simple SELECT...FROM...WHERE query. No .css or anything like that.

---

<div class="post-metadata">

**Author:** ![JensHaglof](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@JensHaglof](https://discuss.elastic.co/u/JensHaglof)\
**Post date:** [March 18, 2025, 8:16am UTC](https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899/3 "2025-03-18T08:16:29Z")

</div>

I tried running a query in Discover to see if I could reproduce the error, but it didn’t return any rows. This confirms that the data is correct in Discover, meaning the issue must be with how the data is displayed in Canvas.

Additionally, in Canvas, I tried displaying a simple number instead of a table. I ran:  
`SELECT COUNT(DISTINCT columnX) FROM xxx WHERE columnX = valueThatShouldntBeInColumnX`

and it returned `64`.

Something is definitely wrong.

---

<div class="post-metadata">

**Author:** ![JensHaglof](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@JensHaglof](https://discuss.elastic.co/u/JensHaglof)\
**Post date:** [March 20, 2025, 7:24am UTC](https://discuss.elastic.co/t/split-function-not-working-when-canvas-is-created/375899/4 "2025-03-20T07:24:38Z")

</div>

Hi.  
Problem solved. It turned out that the data was wrong in the Elastic database as well. Apparently it was a parsing problem when the data was loaded into Elastic. When I checked Discover, the column had only one type of data. But someone else at the company I work for could see there was multiple data in that column.