Hi, i have a field which contains column separated values, and i want to convert them into rows and use it for visualization. Can you please help how it can be done in the dataset.
I would start by looking into the Split function
Wouldn’t the split function in QuickSight just create new columns? To split the value into rows, it seems like you would have to use something like the STRING_SPLIT function in SQL Server but I don’t know if that’s supported in QuickSight.
At this point in time QuickSight data preparation capabilities are limited and don’t let you convert a single row into multiple rows. You will need to perform this transformation in another tool. Take a look at AWS Glue Databrew or AWS Glue Studio if you cannot use custom SQL for it.