Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

If statement to duplicate and modify row

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

1 Reply
Highlighted

Re: If statement to duplicate and modify row

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';