'Domo - Split multi value comma-delimited column based on values

I have a data source in Domo with a multi value column that is comma delimited. I am able to split the column using the comma as delimiter, into new columns. Example-

  • fruit, vegetables Gives new column 1 Fruit and new column 2 vegetables
  • Vegetables, meat Gives new column 1 vegetables and new column 2 meat

I need it to group all fruit into one column and all vegetables into another.

How can I do this?

multivaluedomo


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions