topic Re: converting table in required format in QlikView

converting table in required format

kapil_rthr — Wed, 06 Nov 2019 06:52:13 GMT

i have following table:

ISSUE_ID	CUSTOM_FIELD_NAME	STRINGVALUE	NUMBERVALUE
7553531	Time in Status	(null)	1
7553531	Severity	Blocker	(null)
7553531	Actual Time Worked (Hours)	(null)	12
7553532	Time in Status	(null)	2
7553532	Severity	Blocker	(null)
7553532	Actual Time Worked (Hours)	(null)	20

i want to load the data into following format:

ISSUE_ID	Time in Status_STRINGVALUE	Time in Status__NUMBERVALUE	Severity_STRINGVALUE	Severity_NUMBERVALUE	Actual Time Worked (Hours)_STRINGVALUE	Actual Time Worked (Hours)_NUMBERVALUE
7553531	(null)	1	Blocker	(null)	(null)	12
7553532	(null)	2	Blocker	(null)	(null)	20

Re: converting table in required format

tresB — Wed, 06 Nov 2019 07:27:44 GMT

Try using Generic Reload

Re: converting table in required format

Arthur_Fong — Wed, 06 Nov 2019 07:29:11 GMT

Try using generic load:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: converting table in required format

Brett_Bleess — Tue, 12 Nov 2019 13:27:17 GMT

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