You’re offline. This is a read only version of the page.
Announcements
8
Hey Yall
Im struggling with a need.
i've one table like this
| id | Process | description |
| 1 | process number 1 | this is process number 1 |
| 2 | process number 2 | this is process number 2 |
| 3 | process number 3 | this is process number 3 |
| 4 | process number 4 | this is process number 4 |
i've a secont table like this
| id Process | Process | steps |
| 1 | process number 1 | this is the first step |
| 1 | process number 1 | this is the second step |
| 1 | process number 1 | this is the third step |
| 1 | process number 1 | this is the fourth step |
| 1 | process number 1 | this is the ... Step |
| 2 | process number 2 | this is the first step |
| 2 | process number 2 | step is number 2 |
| 2 | process number 2 | this is the step third |
| 2 | process number 2 | fourth step |
the goal is join tables where the column steps become a collection within the first collection, like this
| id | Process | description | Steps |
| 1 | process number 1 | this is process number 1 | collection of table 2 with all the steps of the process based on Id Process |
| 2 | process number 2 | this is process number 2 | collection with all the steps of the process based on Id Process |
| 3 | process number 3 | this is process number 3 | if no steps, then blank |
| 4 | process number 4 | this is process number 4 | if no steps, then blank |
Any advice?
Hi @Mattzinq，
Try the following formula:
Share
Report
All responses (
Answers (
AddColumns(Table1,"steps",LookUp(GroupBy(Table2,"idProcess","IdG"),idProcess=id).IdG)
