Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to modify table data while loading?

Hi,

I have a table as described below:

IM     RUN     

1234     20     

1234-10     0     <== IM changed as it's less than the previous one

1234     11     

1234     23     

1234     40     

1234-14     7     <== IMchanged as it's less than the previous one

1234     12     

1234     30     

Now what I need to do is to change all the occurences of IM till RUN is again less than the previous RUN:

IMEI     RUN

1234     20

1234-10     0

1234-10     11

1234-10     23

1234-10     40

1234-14     7

1234-14     12

1234-14     30

I tried to use loop but it didn't work properly, can anyone help with this?

0 Replies