rename datas

[#1]

Hi every body,

I have a table:

Items

Jouet

Cadeaux

Décoration

Toys

Gift

Decoration

and I want to put Toys into Jouet, Gift into Cadeux and Decoration into Décoration in order to get one and only table which is:

Items

Jouet

Cadeaux

Décoration

whithout loosing any datas

Can someone help me?

[sparur]

Hello, Bob.

What are:

Jouet

Cadeaux

Décoration

Toys

Gift

Decoration

?

Is it name of fields or it's values of field Items?

[Anonymous]

It doesn't make any sens.

[#4]

HI,

Jouet

Cadeaux

Décoration

Toys

Gift

Decoration

are values of the field items

for exemple a table like this:

Item | Quantity

Jouet | 5

Cadeaux | 10

Décoration | 15

Toys | 20

Gift | 25

Decoration | 30

I finally want the table:

Item | Quantity

Jouet | 25

Cadeaux | 35

Décoration | 45

[johnw]

Perhaps this?

[Translate to French]:
LOAD * INLINE [
From, To
Toys, Jouet
Gift, Cadeaux
Decoration, Décoration
];
LOAD
applymap('Translate to French',Item) as Item
,Quantity
...
;

[#6]

hi,

thanks for your reply, the idea seems to be good, but it is not working, it says there is a Script Error...

Other ideas ???

[johnw]

Ah, oops, I missed a critical key word. Sorry about that.

[Translate to French]:
MAPPING LOAD * INLINE [
From, To
Toys, Jouet
Gift, Cadeaux
Decoration, Décoration
];
LOAD
applymap('Translate to French',Item) as Item
,Quantity
...
;

[#8]

still the same problem.... even when I added the key word MAPPING...

[johnw]

Works for me. See attached.

[#10]

Hi, thanks for your reply.

Lot of thanks for your help 🙂

Now I have an other problem...maybe you can help me if it isn't disturbing you...??? I was supposed to be able to resolve it with the first problem but it doesn't seem to be that easy...

Actually what I really wanted to do is to join 2 columns of 2 different Excel files, for exemple: I have one Excel file which contains:

Item | Quantity

Toys | 20

Gift | 25

Decoration | 30

And an other excel fil which contains:

Item | Quantity

Jouet | 5

Cadeaux | 10

Décoration | 15

And I want in qlikview one table with contains:

Item | Quantity

Jouet | 25

Cadeaux | 35

Décoration | 45

The problem is that those two table are in two different excel files so when I join them, the results (colum quantity) should be the addition of the two but it is not...