Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik,
Please can any one help on this.
Here StudentName and Feedback. In Feedback there is a three records i.e., Fail, Pass, Stable.
I want split this records data in to fields and place with 1 as i mentioned in excel.
Thanks in advance.
Hi,
Try this
Load
StudentName,
Feedback,
if(Feedback='Fail',1) as Fail,
if(Feedback='Pass',1) as Pass,
if(Feedback='Stable',1) as Stable
From TableSource;
Regards,
Devyanshu
load where feedback = fail concat load where feedback=pass concat load where feedback=stable
Thanks for your response Bram,
By using this,can we get the output and how to get new fields Pass and Fail and stable. Please suggest
Hi,
Try this
Load
StudentName,
Feedback,
if(Feedback='Fail',1) as Fail,
if(Feedback='Pass',1) as Pass,
if(Feedback='Stable',1) as Stable
From TableSource;
Regards,
Devyanshu
in your load script
use following code:
load studentName,Feedback,if(wildmatch(feedback,'fail'),1,null()) as fail,
if(wildmatch(feedback,'pass'),1,null()) as pass,
if(wildmatch(feedback,'stable'),1,null()) as stable
resident your table name;
I didn't read the question correctly. My bad. This Solution is the right one.
Hi Aravind,
Thanks for your great support. Using by Wildmatch also we will get the output. Thanks again