As you noticed your partition by clause is improper since your row_number()
counts all of the members that are the same -- instead of sequencing a run
of the same values.
Here's a POC using a simplified version of your dataset:
You can adjust the grouping windows and change detection accordingly.
Can someone look into this and revert if possible?
Regards,
Anup Tiwari
On Sat, Jul 14, 2018 at 12:28 AM, Anup Tiwari
wrote:
> Hi All,
>
> Can someone look into this and revert if possible?
>
> Thanks.
>
>
> On Thu, 12 Jul 2018 12:56 Anup Tiwari, wrote:
>
>> Hi All,
>>
>> We have a use case w
Hi All,
Can someone look into this and revert if possible?
Thanks.
On Thu, 12 Jul 2018 12:56 Anup Tiwari, wrote:
> Hi All,
>
> We have a use case where we want to assign a row number to a table based
> on 3 column ( uid, update_date, flag) i.e. if value of any of the column
> gets changed, we
Hi All,
We have a use case where we want to assign a row number to a table based on
3 column ( uid, update_date, flag) i.e. if value of any of the column gets
changed, we want to reset this number. Please find below sample input data
and expected output data.
Also please note that we have tried r
