Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to get the difference in the comma separated values. For example if i have the table as
Key, ct
A,10,20,30,40
B, 20,50,70
c, 1,2
so i am looking for
Key, ct
A, 10,10,10 ------> Got the values in ct by 20-10,30-20,40-30
B, 30,20 ------> Got the values in ct by 20-50,50-70
c, 1 ------> Got the values in ct by 2-1
so on..... it is calculating the difference in the dynamic comma separated values without splitting into multiple columns. but it would be consistent as per the above example.
Does evaluate works on date/timestamp?
Yes, it does