Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Hi
I have a spreadsheet created by another system which looks like this:
Code | Grade | A | B | C | D | E |
M1412 | Cruise | 1 | 2 | 3 | 4 | 5 |
Flight | 2 | 3 | 1 | |||
M1413 | Cruise | 2 | 4 | 6 | 8 | |
Flight | 1 | |||||
I would like to load the data as follows:
Code | Grade | Cruise | Flight |
---|---|---|---|
M1412 | A | 1 | 2 |
M1412 | B | 2 | 3 |
M1412 | C | 3 | 1 |
M1412 | D | 4 | |
M1412 | E | 5 | |
M1413 | A | 2 | 1 |
M1413 | B | 4 | |
M1413 | C | 6 | |
M1413 | D | 8 | |
M1413 | E |
Is this possible using Excel import parameters, or QV LOAD parameters? Or is this step too far?
Thanks
Richard