Need help!

[#1]

I have survey response for more than 100 questions like

No Knowledge/Experience

Beginner

Applying

Leading

Expert

I want to predefine them as number like 1 -5. So each time when load a file (Responses are in different  file) it should automatically consider the response as numbers. Is there a way in qlikview to do that . please help.

[sunny_talwar]

May be create a Mapping Table:

MappingTable:

Mapping

LOAD * Inline [

Response, NumResponse

No Knowledge/Experience, 1

Beginner, 2

Applying, 3

Leading, 4

Expert, 5

];

FactTable:

LOAD Responses,

          ApplyMap('MappingTable', Responses) as Numbered_Response

From Source;

[maxgro]

another could be

load Response, AutoNumber(Response) as ResponseId inline [

Response

No Knowledge/Experience

Beginner

Applying

Leading

Expert

];

load

  AutoNumber(Response) as ResponseId,

  ......     // other fields

From YourFile;