topic Re: How do i rename these cells in table below in QlikView

How do i rename these cells in table below

Mon, 09 Mar 2015 12:09:25 GMT

Hello,

I have a table and I want Zenith and Zain in the table below load as ZN. how do I load this table. note that the table is incremental new data and new name are coming.

load * inline[

A, B, C

1, Zenith, 23

2, ECO, 40

3. UBA, 56

4.OCHE, 29

5. YYY, 67

6.RRR, 21

7.Zain, 56

]

Re: How do i rename these cells in table below

puttemans — Mon, 09 Mar 2015 12:13:53 GMT

Hi,

Probably easiest would be to work with a mapping load for those 2 names (you can extend it later to other names as well).

Map_ZN

MAPPING Load * inline [

Name, Newname

Zenith, ZN

Zain, ZN ]

And then finish with a maping load on the B-variable on the data that you add.

Applymap ('Map_ZN', B) as B

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 12:37:54 GMT

am loading from excel and I have to load all the data not only Zenith and Zain

Re: How do i rename these cells in table below

puttemans — Mon, 09 Mar 2015 12:39:29 GMT

Of course you do. But your initial question was to rename Zenith and Zain into ZN...

Can you attach your script?

Re: How do i rename these cells in table below

chrislofthouse — Mon, 09 Mar 2015 12:49:44 GMT

Do as Johan mentions but use this instead:

Applymap ('Map_ZN', B,B) as B

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 13:05:23 GMT

Its same question not changing the topic. Am loading a set of data from a table and I want to rename two different data into 1, that is why I said the table is incremental

Re: How do i rename these cells in table below

puttemans — Mon, 09 Mar 2015 13:09:18 GMT

Hello,

I'm not discussing linguistic issues. I'm just trying to help. Now, if you could upload your script, then I can help you 10x faster than right now.

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 13:14:03 GMT

I don't understand you, am loading from QVD . just gave you a scenario

Re: How do i rename these cells in table below

Colin-Albert — Mon, 09 Mar 2015 13:14:55 GMT

Hi Christopher,

You do not need to have B,B in your apply map expression.

If the mapping fails to find a match the original value is returned unless a default value is included.

So Applymap ('Map_ZN', B) as B will return either the mapped value or the data in B

Re: How do i rename these cells in table below

Colin-Albert — Mon, 09 Mar 2015 13:18:24 GMT

Try something like this. The mapping table will be automatically deleted on completion of the load.

Name_Map:

MAPPING Load * inline [

Name, New

Zenith, ZN

Zain, ZN

] ;

Load

Applymap('Name_Map', B) as B,

from your_qvd_file.qvd (qvd) ;

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 13:26:33 GMT

Load

Vendor,

ID,

Text

FROM
($datapath)Vendor.QVD]
(qvd);

And the cells am trying to rename are in the Vendor field

Re: How do i rename these cells in table below

puttemans — Mon, 09 Mar 2015 13:29:08 GMT

Then please try this :

Map_ZN

MAPPING Load * inline [

Name, Newname

Zenith, ZN

Zain, ZN ];

Load

Applymap ('Map_ZN', Vendor) as Vendor,

ID,

Text

FROM
($datapath)Financial_Statement.QVD]
(qvd);

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 14:12:14 GMT

let me try

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 16:48:35 GMT

Oops didn't work

Re: How do i rename these cells in table below

awhitfield — Mon, 09 Mar 2015 17:00:21 GMT

Map_ZN:

MAPPING Load * inline [

Name, Newname

Zenith, ZN
Zain, ZN ];

DATA:
load * inline [

A, B, C
1, Zenith, 23
2, ECO, 40
3, UBA, 56
4,OCHE, 29
5, YYY, 67
6,RRR, 21
7,Zain, 56

];

NoConcatenate
DATA2:
Load
A,
Applymap('Map_ZN', B) as B,
C

Resident DATA;

Drop table DATA;

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 17:31:10 GMT

Please am confuse here find attached. excel file

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 17:33:35 GMT

Please find attached am confused I tried it didn't work

Re: How do i rename these cells in table below

Mon, 09 Mar 2015 18:04:16 GMT

Find qvw file, not working

Re: How do i rename these cells in table below

puttemans — Tue, 10 Mar 2015 07:56:41 GMT

Good morning,

Please find attached the working file. You had 2 issues in your script; a datapath that was undefined at the start, and the correct variable not being used in the applymap function.

Kind regards,

Johan