Discussion Board for collaboration on QlikView Scripting.
I have a question, I have a table in DB with many field that have this name:
I need to load every Item field anf quantity with the same field name.
I try with this:
For i=1 to 3
LOAD 'ItemID' + text(num(i,'00')) AS ItemID.
'Quantity' + text(num(i,'00')) AS Quantity
but seem that QlikView dont resolve names of field 'ItemIDxx and Quantityxx.
SO I dont know wich is the right syntax.
Please can you help me?
Thank you very much.
Solved! Go to Solution.
here QVW file.
I need to have the names of fields (for example if i is equal 2 I need to have ItemID02 and Quantity02).
I dont know if this is possible, if not is a great prblem, in database I have an arry for every record.
FROM (Database Table):
IDKEY ItemID01 ItemID02 ItemID03 Quantity01 Quantity02 Quantity03
1 A B C 5 10 8
2 E A D 8 1 9
Temp (Qlikview Table):
IDKEY ItemID Quantity
1 A 5
1 B 10
1 C 8
2 E 8
2 A 1
2 D 9
Is it impossible?