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?
To clarify, i want my action to run based on Count(LIST(โtable nameโ[EMP ID]))
Each action will execute
INDEX(SPLIT([EMP ID],","),
Count(LIST(โtable nameโ[EMP ID])))
This way, i dont have to pre create actions for all possible outcomes
Thanks
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |