topic how to create new feild based on existing in QlikView

how to create new feild based on existing

ilanbaruch — Wed, 28 May 2014 14:52:05 GMT

i have a list of agents A1, A2, B1, B2, B3, C2, C3 ,C4 ....

i want to categorise agents A, B and C

(create fiels for A agents, B agents, C)

bbi_mba_76 — Wed, 28 May 2014 15:14:31 GMT

Hi,

I don't understand so well, but maybe the attached file could help.

ashfaq_haseeb — Wed, 28 May 2014 15:19:57 GMT

Hi may be like this

Agents_Main:

Load Agents,

left(Agents,1) as Agent_Groups;

LOAD * INLINE [

Agents

];

Regards

ASHFAQ

maxgro — Wed, 28 May 2014 16:56:43 GMT

Load agents,

// this (3 fields)

if(left(agents,1)='A',1,0) as agent_a,

if(left(agents,1)='B',1,0) as agent_b,

if(left(agents,1)='C',1,0) as agent_c,

// or this?

left(agents,1) as agentgroup

;

LOAD * INLINE [

agents

];