topic Re: How to replace ID as Name in Straight table in QlikView

How to replace ID as Name in Straight table

Mon, 23 Sep 2013 16:41:52 GMT

Hi,

I have a column ID with values 1000,1001. I need to replace this values 1000 as Alex and 1001 as Rob.

Could anyone let me know how to write the expression in Straight table or script in Load.

Thanks.

Re: How to replace ID as Name in Straight table

Mon, 23 Sep 2013 18:30:12 GMT

try something like

load id,

'1000' as Alex,

'1001' as Rob

from ...

or look into applymap function

Re: How to replace ID as Name in Straight table

manas_bn — Mon, 23 Sep 2013 18:48:44 GMT

load

if(ID=1000,'Alex',if(ID=1001,'Rob',ID)) as ID

Resident Table;

Add a calculated dimension

if(ID=1000,'Alex',if(ID=1001,'Rob',ID))

Re: How to replace ID as Name in Straight table

Carlos_Reyes — Mon, 23 Sep 2013 19:26:13 GMT

As Christopher said Applymap is a good idea since its likely that you'll need to replace more ID values with Names, but if you don't you can use an IF.

LOAD

ID,

IF (ID= 1000, 'Alex', IF(ID= 1001, 'Rob', ID)) AS Replaced_ID

FROM TABLE

;

Re: How to replace ID as Name in Straight table

v_iyyappan — Mon, 23 Sep 2013 19:33:30 GMT

Hi,

Use Apply map concept you can get the name.

Please check the following link

ApplyMap

Regards,

Re: How to replace ID as Name in Straight table

MayilVahanan — Mon, 23 Sep 2013 19:37:28 GMT

Try with mapping and applymap concept.

MappingName:

mapping load * inline

[

Id, Name

1000,Alex

1001, Rob

];

Load ApplyMap('MappingName',Id) as Id from tablename;

Re: How to replace ID as Name in Straight table

Anonymous — Mon, 23 Sep 2013 19:52:35 GMT

In table expression
pick(match(1000,1001),'Alex','Rob')

Regards,
Michael

Re: How to replace ID as Name in Straight table

rustyfishbones — Mon, 23 Sep 2013 20:05:48 GMT

Try this,

IF(ID = 1000, 'ALEX', IF(ID = 1001, 'Rob',ID))

I hope it helps

Re: How to replace ID as Name in Straight table

Tue, 24 Sep 2013 07:41:10 GMT

Thanks for your answer it's working.