Forum Discussion
Problem with duplicates
Hello, I need some help with data transformation. I have table like below: And I need to have all data in one row for cases with new o revisit not blank. This is hard becouse there could b...
| sCRM_ID | New_or_revisit | Index | New case | Revisit | Case assigned | Data sufficient | Case done |
| 17.KR.784811 | New | 24 | 03.08.2018 11:12 | ||||
| 17.KR.784811 | 25 | 03.08.2018 11:24 | |||||
| 17.KR.784811 | 26 | 03.08.2018 11:24 | |||||
| 17.KR.784811 | 31 | 03.08.2018 13:14 | |||||
| 17.KR.784811 | 95 | 08.08.2018 08:54 | |||||
| 17.KR.784811 | 96 | 08.08.2018 08:54 | |||||
| 17.KR.784811 | Revisit | 97 | 08.08.2018 08:54 | ||||
| 17.KR.784811 | 100 | 08.08.2018 09:19 | |||||
| 17.KR.784811 | 114 | 09.08.2018 04:50 | |||||
| 17.KR.784811 | 115 | 09.08.2018 04:50 | |||||
| 17.KR.784811 | Revisit | 116 | 09.08.2018 04:50 | ||||
| 17.KR.784811 | 122 | 09.08.2018 07:42 | |||||
| 17.KR.784811 | Revisit | 3327 | 20.12.2018 07:56 | ||||
| 17.KR.784811 | 3328 | 20.12.2018 08:02 | |||||
| 17.KR.784811 | 3329 | 20.12.2018 08:02 | |||||
| 17.KR.784811 | 3351 | 20.12.2018 11:31 | |||||
| 17.KR.784811 | 3352 | 20.12.2018 11:39 | |||||
| 17.KR.784811 | Revisit | 3615 | 09.01.2019 09:14 | ||||
| 17.KR.784811 | 3616 | 09.01.2019 09:16 | |||||
| 17.KR.784811 | 3617 | 09.01.2019 09:16 | |||||
| 17.KR.784811 | 3621 | 09.01.2019 09:40 |
is this ok?
Hi, any ideas?