Hello
I have a table in which i have a list of values. I wish to split these values into separate values and then add a new row action with each value.
so far i have managed doing so when i know in advance the number of values in the list and then created an action for each value using this for example INDEX(SPLIT([EMP ID],","),2)
Is there a way to do so when i have many values in the list and with only one action?
Thanks
Nope.
So an action per value as i did?
Thatโs the easiest way, yes.
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |