QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Who Me Too'd this topic

richard_chilvers
Specialist
Specialist

Transpose, Crosstable, Something Else ?

Hi

I have a spreadsheet created by another system which looks like this:

CodeGradeABCDE
M1412Cruise12345
Flight231
M1413Cruise2468
Flight1

I would like to load the data as follows:

CodeGradeCruiseFlight
M1412A12
M1412B23
M1412C31
M1412D4
M1412E5
M1413A21
M1413B4
M1413C6
M1413D8
M1413E

Is this possible using Excel import parameters, or QV LOAD parameters? Or is this step too far?

Thanks

Richard

Who Me Too'd this topic