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: 
rkpatelqlikview
Creator III
Creator III

Splitting records in to Fields and cell should be place with number 1

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.

split.PNG

1 Solution

Accepted Solutions
devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

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

View solution in original post

6 Replies
bramkn
Partner - Specialist
Partner - Specialist

load where feedback = fail concat load where feedback=pass concat load where feedback=stable

rkpatelqlikview
Creator III
Creator III
Author

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

devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

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

arvind1494
Specialist
Specialist

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;

bramkn
Partner - Specialist
Partner - Specialist

I didn't read the question correctly. My bad. This Solution is the right one.

rkpatelqlikview
Creator III
Creator III
Author

Hi Aravind,

Thanks for your great support. Using by Wildmatch also we will get the output. Thanks again