Discussion Board for collaboration related to QlikView App Development.
Does anyone know of a way that I can do an IF statement in a load script, when the condition is true the duplicate the row and make a modification to a value in a field. ie;
If(Jobtitle like 'Director' and Region like 'East', (copy all rows and modify [Manager] = 'newname'), (do nothing))
May be you are looking for Where statement:
LOAD 'Newname' as Manager,
Where Jobtitle like 'Director' and Region like 'East';