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: 
victor_greffet
Partner - Contributor III
Partner - Contributor III

Loop for testing different columns

Hi community !

I need your help,

In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year

I have five differents type of dates :

DATA :

ID

Step0Step1Step2Step5Step9

1

12/12/201710/12/201710/12/201718/12/201718/12/2017
201/01/201710/12/201713/12/201718/12/201718/12/2017
312/12/201710/12/201710/12/201725/12/201725/12/2017
410/12/201710/12/201718/12/201718/12/201718/12/2017
........
n12/12/201710/12/201710/11/201718/12/201718/12/2017

What I want :

DATA :

IDStep0Step1Step2Step5Step9Test

1

12/12/201710/12/201710/12/201718/12/201718/12/2017ok
201/01/201710/12/201713/12/201718/12/201718/12/2017Warning Step0 it's 01/01
312/12/201710/12/201710/12/201725/12/201725/12/2017
Warning Step5 it's 25/12 , Warning Step9 it's 01/01
410/12/201710/12/201718/12/201718/12/201718/12/2017ok
........
n12/12/201710/12/201710/11/201718/12/201718/12/2017

ok

Do you  have an idea ?

Thank you !

Victor

0 Replies