Hi team,
We have two columns Column1 and Column2 , We need to count column1 and apply group by on Column2 . If count result is greater or equal than 3, then set flag = 1 other wise 0. This flag will be new dimension. We are trying to do it at backend not on front end.
Column1 | Column2 | Flag | Logic |
3034032f4405f28019ed9f13 | wEypp3W | 1 | if (count(Column1) group by Column2)>3, 1 0) |
3034032f4405f28019ed9fd2 | wEypp3W | 1 | if (count(Column1) group by Column2)>3, 1 0) |
3034032f4405f28019ed9fd3 | wEypp3W | 1 | if (count(Column1) group by Column2)>3, 1 0) |
3034032f4405f28019ed9fd4 | n9Wxxm2 | 0 | |
3034032f4405f28019ed9fd6 | n9Wxxm2 | 0 | |
3034032f4405f28019ed9fd1 | K789wX | 0 | |
3034032f4405f28019ed9fd7 | J2dggXr | 0 | |
3034032f4405f28019ed9fd8 | 75Ckg4A | 0 |