create new field based on the string

[karan_kn]

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

[Saravanan_Desingh · Accepted solution]

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