issue

[Anonymous]

hi eveyone

needs to one more fields which include tested data of max date

[antoniotiman]

'tested data of max date' (assuming max date 10/06/2017) is 'scheduled'.

Why in Your field output is 'Pass' ?

[sujeetsingh]

Shweta,

Please come in clear words that what you need.

[el_aprendiz111]

Hi,

1 example:

LOAD *, if(len(Previous(Tested))=0,Tested,Previous(Tested)) AS Tested_ll;

LOAD * Inline [

GEL ID,Contigency Date,Tested

10360,21/02/2015,Pass

10360,21/05/2016,Pass

10360,10/06/2017,Scheduled

] ;

EXIT Script;

[Anonymous]

can we achieve the same by front end