Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
Partner

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
Partner

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
Partner

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

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
Partner

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