Discussion board where members can get started with Qlik Sense.
how can i recode a categorical textfield into a new dummy textfield?
i know how to do it with the INLINE command:
Pick(Match(Status, 'DELETED', 'ERROR' ,Status), 'nein', 'nein', 'ja') as Status1;
LOAD * Inline [
Is there a way to work with if-Statements in the load script?
Go to Solution.
if(Stats='DELETED' or Status='ERROR',NO,YES) as Status1
correct me if understand your query wrongly.
Thank you so far. But it doesn't seem to work as intended.
"No" works and picks the right values. "Yes" doesn't work:
Is it possible that 'NEW' and 'PUBLISH_ERROR' do not (or did not) exist in the table being loaded with the attribute expression?
They could exist in another table, or they could have been added later. These tow value seem not to have a null/missing value for Status1.
Jonathan, you are absolutely right. I've checked the real value Distribution and both are not present anymore, but have been Status-values once. Good Job.