I’ve some requirement where i need to assign value from one table to another table based on weighted scenario . I was able to get value of that weight as number . Now im kind of stucked how i can assign only first non empty rows as a value.
For instance in this example W_ value is 4 for first 4 non empty rows.
Let me know what you think about it