topic Re: create new field based on the string in QlikView

create new field based on the string

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

If status field contains 'PROGRESS', Create a new field (PROGRESS else DONE)

LOAD * INLINE [
ID, Status
1, Projectx AA sfdfdsfdf PROGRESS
2, Projects sdfsdfA dfgdfg
3, Projectu AdsfA tryth PROGRESS
4, Projectf AgnfA cfdfgdfg
5, Projectd AdfdfA dfgdnn
6, Projectc AfdgfA cvbcbtg PROGRESS
7, Project AfgdfgA fgfdsgdfg PROGRESS
];

Re: create new field based on the string

Saravanan_Desingh — Wed, 24 Jun 2020 20:00:27 GMT

one solution is.

tab1: LOAD *, If(Upper(Status) Like '*PROGRESS*', 'Y') As Progress, If(Not(Upper(Status) Like '*PROGRESS*'), 'Y') As Done; LOAD * INLINE [ ID, Status 1, Projectx AA sfdfdsfdf PROGRESS 2, Projects sdfsdfA dfgdfg 3, Projectu AdsfA tryth PROGRESS 4, Projectf AgnfA cfdfgdfg 5, Projectd AdfdfA dfgdnn 6, Projectc AfdgfA cvbcbtg PROGRESS 7, Project AfgdfgA fgfdsgdfg PROGRESS ];