Create Fields based on the values

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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
];

Re: Create Fields based on the values

Vegar — Mon, 30 Mar 2020 15:14:13 GMT

You can use the GENERIC functionality in QlikView.

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

topic Create Fields based on the values in QlikView

Create Fields based on the values

Re: Create Fields based on the values