I have a dataset in impala SQL like this: And I want to look like this: I have tried using CASE WHEN but results in duplicates for those ids where has 2 values different. Can someone help me with this issue. Thenk you much in advance. Answer
I have a dataset in impala SQL like this: And I want to look like this: I have tried using CASE WHEN but results in duplicates for those ids where has 2 values different. Can someone help me with this issue. Thenk you much in advance. Answer