If statement to duplicate and modify row

[#1]

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

[sunny_talwar]

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