topic very hard? please help.. in QlikView

very hard? please help..

Fri, 04 Dec 2009 23:34:48 GMT

consider this table. In ths case I would to replace
the cmp field where the cmp =fg
If the type of cmp is = fg I have to serach in the column
item and I must to replace the, in this sample, ccd eith j
becouse ccd= j in the column item

load * Inline [

item , vmp, type

abc , ccd , fg
abc , a , rm
abc , k , rm
ccd , j , rm

];

Some genius could to try to help me?
Thanks
best regards,
Slash

very hard? please help..

johnw — Sat, 05 Dec 2009 00:41:26 GMT

Perhaps this:

RawData:
load * Inline [
item , vmp, type
abc , ccd , fg
abc , a , rm
abc , k , rm
ccd , j , rm
];
Map:
MAPPING LOAD
item as vmp
,only(vmp) as newvmp
RESIDENT RawData
GROUP BY item
;
Data:
NOCONCATENATE LOAD
item
,if(type='fg' and len(applymap('Map',vmp)),applymap('Map',vmp),vmp) as vmp
,type
RESIDENT RawData
;
DROP TABLE RawData
;

I'm sure there would also be a way to do it with a bunch of joins without adding additional tables if memory usage during the load is a concern.

(Edit: added NOCONCATENATE)

very hard? please help..

Sat, 05 Dec 2009 01:15:26 GMT

it seams doesn't work 😞

very hard? please help..

johnw — Sat, 05 Dec 2009 01:20:06 GMT

Debugged version attached. It simply needed NOCONCATENATE in the Data load to avoid concatenating to RawData and subsequently being dropped.

very hard? please help..

Sat, 05 Dec 2009 01:34:13 GMT

Many Tganks.

Now I trued the example in the "real problem".

Best Regards,

Slash

Ciao