Comments
-
Yes, @Grant ..
-
-
Hi @GrantSmith : There are null values as well in the column values, Think cause of that it is failing.. I retried by mapping nulls to NA, still no luck.. CASE WHEN SUM(SUM(1)) OVER (PARTITION BY `Email`) = 1 THEN 'Unique' ELSE 'Duplicate' END Could you please suggest how to tackle same
-
Okay, will try this.. Thank you for the quick help, Very much appreciated :)
-
Hi @GrantSmith , Thank you for the solution, I have requested to get the window functions in beast mode. Unfortunately, it might take sometime :( Could you please let me know if you have any other solution in mind..
-
Hi Grant, I found the issue.. Thanks :)