Need data from split to be used in choice

[paiboolk]

Hi all,I got data from multiple choice and record in a cell called “machine”, e.g., “mc01,mc02,mc03”. And I tried to use split to separate these data for use with choice. But It doesn’t work out.
How can I separate these data and display in choice component?

[Darren_Murphy]

You need to transpose the array into a list with a helper table.

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

[Jeff_Hager]

Do those machine IDs already exist in another table? If so you can use the Split column to create a Relation to the machine table. Then source your choice component from the relation.

[Hassan_Nadeem]

If you don’t have those machine IDs already in another table, then you can use AI component to create a custom choice component.

[paiboolk]

Thank you. I will try.