compare value within columns

[beck_bakytbek]

Hi Folks,

i got a question: how can i compare value within 2 columns, i solved a part of my issue by using this expression:

if( column1 = column2, 'yes','no') as compare

but what if, i want to compare the value which i loaded yesterday with value wich i loaded today and all those values i compare in the form: column1 vs column2.

For more clarity, please see the attached screenshot.

Does anybody have any ideas?

Thanks a lot

Beck

[marinadorcassio1]

Hi Beck,

Check the Above() function, it may help you

Regards,

Marina

[beck_bakytbek]

Hi Marina,

thanks a lot for your responce, but i used this function and i achieved no results

Thanks a lot for your time and responce

[marinadorcassio1]

if( Above(column1) = column2, 'yes','no') didn't return any result or not what you want ?

[beck_bakytbek]

Hi Marina,

thanks a lot for your responce, lets imagine

Column1: the first row contains the number: 4 and this number i recieved on 28.08.2018

Column2: the fifth row contains the number: 4 and this number i recieved on 02.09.2018

and if i use the above () - function, then i am forced to build the if-expression for instance. if(above(column1) = column1, if then..if then,,.. but i dont achieve the expected results, i dont know how to compare the rows within two different columns

thanks a lot

[marinadorcassio1]

Ok, then why don't you create a new filed in your script, like

if(exists(column1, column2), 'yes', 'no') as Compare ?

[beck_bakytbek]

Marina, thanks a lot for your responce,

i will implement it and if i solve this issue, i give your my feedback

[passionate]

There might be some key column defining the which row to compare between yesterday and today.

Use that key as dimension and compare both data.

Please post sample data for accurate answer.

[beck_bakytbek]

Hi Thakur,

thanks a lot for your responce, as sample you can see my attached sreenshot

[marinadorcassio1]

Did you archieve what you want ?