Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kapil_rthr
New Contributor II

converting table in required format

i have following table: 

ISSUE_IDCUSTOM_FIELD_NAMESTRINGVALUENUMBERVALUE
7553531Time in Status(null)1
7553531SeverityBlocker(null)
7553531Actual Time Worked (Hours)(null)12
7553532Time in Status(null)2
7553532SeverityBlocker(null)
7553532Actual Time Worked (Hours)(null)20

 

 

i want to load the data into following format:

 

ISSUE_IDTime in Status_STRINGVALUETime in Status__NUMBERVALUESeverity_STRINGVALUESeverity_NUMBERVALUEActual Time Worked (Hours)_STRINGVALUEActual Time Worked (Hours)_NUMBERVALUE
7553531(null)1Blocker(null)(null)12
7553532(null)2Blocker(null)(null)20
3 Replies
MVP
MVP

Re: converting table in required format

Try using Generic Reload 

Partner
Partner

Re: converting table in required format

Try using generic load:

MC.PNG

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Support
Support

Re: converting table in required format

Kapil, did Arthur's example app get you what you needed on this one?  If so, please be sure to give him credit for the help by using the Accept as Solution button on his post if it did.  If you are still working on things, please leave an update.  

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.