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?
You need to transpose the array into a list with a helper table.
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.
If you don’t have those machine IDs already in another table, then you can use AI component to create a custom choice component.
Thank you. I will try.