I can’t seem to find the answer for this although I’m sure it’s simple (though not for me apparently). I want to use multiple rows from one table to populate multiple rows in a 2nd table. The goal is to use a master list to select and build a customized list and populate the 2nd table with the customized list. Sounds simple but when I use the action “add a new row to another table using values from this row”, it only works if I select one row. If I select two or more I get an error indicating the key already exist in that row. It looks like it’s trying to put the info from all selected rows from the master list into a single row in the customized list. Do I have to somehow use a loop for this or am I going about this the wrong way? Any help is appreciated.
Thank you sir. Digging in!
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |