Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create another Column in script

I have this table,

  

TYPEDATE_01DATE_02
AType AType B
BType AType B
AType AType B
BType AType B
BType AType B
BType AType B
AType AType B
AType AType B

and i want to create a new column DATE_03 when if ([TYPE]="A";[DATE_01];[DATE_02])

This would result table

TYPEDATE_01DATE_02DATE_03
AType AType BType A
BType AType BType B
AType AType BType A
BType AType BType B
BType AType BType B
BType AType BType B
AType AType BType A
AType AType BType A
1 Reply
sunny_talwar

May be this:

LOAD TYPE,

          DATE_01,

          DATE_02,

          If(TYPE = 'A', DATE_01, DATE_02) as DATE_03

FROM source;