Create Fields based on the values

[karan_kn]

Please help me to Create fields (Fruit, Vegetables & Value)using Fieldname values in a load script

LOAD * INLINE [
ID, Fieldname, Value
1, Fruit, Orange
1, Value, 548
2, Fruit, Apple
2, Vegetables, Onion
2, Value, 5469
3, Fruit, Pineapple
3, Vegetables, Beans
3, Value, 1245
4, Fruit, Mango
4, Vegetables, Carrots
4, Value, 7895
5, Fruit, Grapes
5, Value, 457
];

[Vegar · Accepted solution]

You can use the GENERIC functionality in QlikView.

Take a look at   @hic  excelent blog post The Generic Load