cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
leandromaiaf Frequent Visitor
Frequent Visitor

Replace information in a column by summarized information of the same column grouped by ID

Hi, evebody

 

I am struggling in trying to replace values in the column MACHINE for the mode of MACHINE considering the table grouped by ID. The column machine may have wrong values pointed, thats why I want to extract the mode a replace. 

 

This is the example of before, as you can see ID 1444 has apointments of MACHINE 4 (mainly) and 1 (probably wrong appointment):

 

1.png

 

I need this result, replace values in MACHINE for the mode of each ID:

 

2.png

 

I filtered the column ID just to examplify the issue, but of course it has many other IDs on it.

 

I did not find nothing related to the operation I need in the community, could you help me?

1 ACCEPTED SOLUTION

Accepted Solutions
leandromaiaf Frequent Visitor
Frequent Visitor

Re: Replace information in a column by summarized information of the same column grouped by ID

I finale could do it. Grouped the original table by ID creating a new table, after that I merged to a new table, this way cyclic reference error did not appear.

 

I'm gonna let this answer here in case.

2 REPLIES 2
leandromaiaf Frequent Visitor
Frequent Visitor

Re: Replace information in a column by summarized information of the same column grouped by ID

Appreciate your help, let me know if I did not make a good explanation

leandromaiaf Frequent Visitor
Frequent Visitor

Re: Replace information in a column by summarized information of the same column grouped by ID

I finale could do it. Grouped the original table by ID creating a new table, after that I merged to a new table, this way cyclic reference error did not appear.

 

I'm gonna let this answer here in case.