How to concat the current and previous values in a single cell.

[rashmithakur]

Hi All,

ID	week	week_diff	missed week
1	12	1
1	15	3	week12 to week 15
1	13	0

Requirement:
If the week_diff >2, then missed_week should have the output from week column as:  week12 to week 15.

I am not getting the output when I am trying to concat the peek value and the current value ( 12, 15) and ordering by ID.

Can someone help on this.

Thanks

[Gysbert_Wassenaar · Accepted solution]

If you're trying this in the front end instead of in the load script then try the Above() function:

If( week_diff>2, 'week ' & above(week) & ' to week '  & week)

[rashmithakur]

Dear Gysbert,

Thanks for your quick response. I tried your proposed script in load editor but with the peek function and it worked.

Thanks a lot