Hello Everyone, i get the data in a 'string list comma separated view' . But i want to feed it in dashboard and i tried SPLIT function but its not working. Any idea so that i can get this data in multiple rows within Quicksight?

Question & Answer
, , , ,
1

image
image483×382 9.77 KB

2

Hi @pkadiyaj ,

Welcome to the community :tada:

Edit your dataset and right click on the three dots. Select “Configure upload settings”.

image
image487×201 11.4 KB

Now QuickSight opens a menu where you can choose a comma separated file format.

image
image596×357 12.6 KB

Best regards,
Nico

If this helped you, please mark my answer as solution. That helpes the community to find solutions faster.

1 Like
3

Hello Nico, Thanks for the promote response. I tried but this won’t works in my case.

image
image1588×315 22.5 KB

Please refer the image as i creating the dummy data for better understanding. in Column 1- 4, data is well maintained but in Column 5 i have around 100 values separated by comma. Thus, after configuring my data it shows only single row which holds 1 value out of 100 values for Column 5 and rest data is not showing.

So in excel if we use (=TEXTSPLIT(column5,“,”) it will explode and shows me all values in 100 different columns but when i’m using (=SPLIT(column5,‘,’,1) it shows just one value which is same happening in CONFIGURE state.

4

Hi @pkadiyaj

Please use the split() function to split data from a comma-separated field.

You will need to use the split() function manually and create individual calculated fields for each value.

Example:

split([Column 5], ',', 1) — First item  
split([Column 5], ',', 2) — Second item  
... and so on.

Please refer to the below documentation this might be helpful for you.

1 Like
5

Hi @pkadiyaj,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post or did one of the solutions provided above help with your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @pkadiyaj,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!