Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
You can use the GENERIC functionality in QlikView.
Take a look at @hic excelent blog post The Generic Load
You can use the GENERIC functionality in QlikView.
Take a look at @hic excelent blog post The Generic Load