Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GauravKumar1
Contributor II
Contributor II

How to create next row in script

Dear Team,

i stuck a requirement that how to create a next row in new field.

requirement is below table

 

DateNameShift inShift Out
01-04-18A7:00:0013:00:00
02-04-18A8:00:0014:00:00
03-04-18A9:00:0015:00:00
04-04-18A10:00:0016:00:00
05-04-18A11:00:0017:00:00
01-04-18B7:00:0013:00:00
02-04-18B8:00:0014:00:00
03-04-18B9:00:0015:00:00
04-04-18B10:00:0016:00:00
05-04-18B11:00:0017:00:00
01-04-18C7:00:0013:00:00
02-04-18C8:00:0014:00:00
03-04-18C9:00:0015:00:00
04-04-18C10:00:0016:00:00
05-04-18C11:00:0017:00:00
01-04-18D7:00:0013:00:00
02-04-18D8:00:0014:00:00
03-04-18D9:00:0015:00:00
04-04-18D10:00:0016:00:00
05-04-18D11:00:0017:00:00
01-04-18E7:00:0013:00:00
02-04-18E8:00:0014:00:00
03-04-18E9:00:0015:00:00
04-04-18E10:00:0016:00:00
05-04-18E11:00:0017:00:00

 

And Output is 

DateNameShift inShift OutNEXT INNEXT OUT
01-04-18A7:00:0013:00:008:00:0014:00:00
02-04-18A8:00:0014:00:009:00:0015:00:00
03-04-18A9:00:0015:00:0010:00:0016:00:00
04-04-18A10:00:0016:00:0011:00:0017:00:00
05-04-18A11:00:0017:00:00  
01-04-18B7:00:0013:00:008:00:0014:00:00
02-04-18B8:00:0014:00:009:00:0015:00:00
03-04-18B9:00:0015:00:0010:00:0016:00:00
04-04-18B10:00:0016:00:0011:00:0017:00:00
05-04-18B11:00:0017:00:00  
01-04-18C7:00:0013:00:008:00:0014:00:00
02-04-18C8:00:0014:00:009:00:0015:00:00
03-04-18C9:00:0015:00:0010:00:0016:00:00
04-04-18C10:00:0016:00:0011:00:0017:00:00
05-04-18C11:00:0017:00:00  
01-04-18D7:00:0013:00:008:00:0014:00:00
02-04-18D8:00:0014:00:009:00:0015:00:00
03-04-18D9:00:0015:00:0010:00:0016:00:00
04-04-18D10:00:0016:00:0011:00:0017:00:00
05-04-18D11:00:0017:00:00  
01-04-18E7:00:0013:00:008:00:0014:00:00
02-04-18E8:00:0014:00:009:00:0015:00:00
03-04-18E9:00:0015:00:0010:00:0016:00:00
04-04-18E10:00:0016:00:0011:00:0017:00:00
05-04-18E11:00:0017:00:00  

 

KINDLY TELL ME HOW TO USE PEEK WITH IF STATEMENT IN ABOVE REQUIREMENT

 

For This i am attaching excel file for row data in sheet 1 

and 

sheet 2 is result part

Labels (1)
10 Replies
GauravKumar1
Contributor II
Contributor II
Author

not working.i used this script