Maybe like this?
INPUT: LOAD Point_id, Type1, Type1Name, Type2, Type2Name, Type3, Type3Name FROM [https://community.qlik.com/thread/171219] (html, codepage is 1252, embedded labels, table is @1); LOAD Point_id, 'Type1' as Type,Type1Name as Name RESIDENT INPUT WHERE Type1; LOAD Point_id, 'Type2' as Type,Type2Name as Name RESIDENT INPUT WHERE Type2; LOAD Point_id, 'Type3' as Type,Type3Name as Name RESIDENT INPUT WHERE Type3; DROP TABLE INPUT;
I know this question has been already answered, but the SQL code will look like the below:
Here is your dataset in SQL:
Here is the lengthy SQL code which will give the desired dataset:
If your Enterprise Data Warehouse (EDW) team keep adding more columns such as "Type4Name", "Type5Name", "Type4", or "Type5", in the SQL end, all you need to do is adding the column name that needs to be unpivotted. Once you bring this data model, the data will flow through your QlikView script.