Help in logic development

[ysalvi]

Hello Team,

Required some help in logic development in the backend script, my requirement is to compare the current record with respect to above record, Please find example below 

Column A, B are input for me required Column C as output 

Thanks in advance 

[vincent_ardiet_]

Look at the previous() function, this should help https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordF...

[ysalvi]

Hello @vincent_ardiet_ 

Have tried this but it is  not working because the output is coming below 

Thanks in advance 

[vincent_ardiet_]

you can change the sort order of your table

[Fabiano_Martino_Intelco]

Hi @ysalvi ,

I got the expected result with this code:

Base_Table:

LOAD * INLINE [

A, B

    ABC, ABC-1

    ABC, ABC-2_1

    ABC, ABC-2_2

    ABC, ABC-3

];

Result_Table:

Load

A as A_Result,

    B as B_Result,

    Peek('B', RowNo(), 'Base_Table') as [Modified B]

Resident Base_Table;

@vincent_ardiet_ is also right, if you can sort the table you can use the previous() function.

Regards