Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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