Forum Discussion
organize data from a table with multiple data for one ID
Hi,
I'm french so i apologize for bad expression
I have an issue to organize my data
I have one table with those collum : ID / Contract ID / statut / Reponse statut
| ID | Contract ID | Statut | Reponse Statut |
| 1111-111-111 | 789 | Clientresponded | refused |
| 2222-22-855 | 789 | Clientresponded | refused |
| 165-454-55-55 | 205 | selected | Accepted |
| 488555-545 | 147 | Client-responded | accepted |
| 118814-55 | 147 | refused | no-followup |
For one CONTRACT ID i can have multiple ID with one statut and one answer
I need if i have multiple ID to make a rules like comparing status and or answer and keep only one ID
Exemple if I have for the same contract ID one statut Client-responded and refused i need to keep the client responded
At the end i need a table with one ID / One Contract ID / one statut / one Reponse statut
Thx and sorry if not clear
Hi nilo0123
Not sure if this is what you want. You can also try selecting the last three columns at the same time, then removing duplicated rows. This uses the Table.Distinct function too.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
3 Replies
Hi nilo0123
Not sure if this is what you want. You can also try selecting the last three columns at the same time, then removing duplicated rows. This uses the Table.Distinct function too.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!sorry for the late answer but it's great thx you
