If statement to duplicate and modify row

Wed, 31 Aug 2016 13:33:08 GMT

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))

Re: If statement to duplicate and modify row

sunny_talwar — Wed, 31 Aug 2016 13:55:12 GMT

May be you are looking for Where statement:

Table:

LOAD Manager,

Jobtitle,

Region,

...

FROM Source;

Concatenate (Table)

LOAD 'Newname' as Manager,

Jobtitle,

Region

Resident Table

Where Jobtitle like 'Director' and Region like 'East';

topic Re: If statement to duplicate and modify row in QlikView

If statement to duplicate and modify row

Re: If statement to duplicate and modify row