Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rename datas

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?

15 Replies
sparur
Specialist II
Specialist II

Hello, Bob.

What are:

Jouet

Cadeaux

Décoration

Toys

Gift

Decoration

?

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

adrian_costar
Contributor III
Contributor III

It doesn't make any sens.

Not applicable
Author

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
MVP
MVP

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
...
;

Not applicable
Author

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
MVP
MVP

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
...
;

Not applicable
Author

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

johnw
MVP
MVP

Works for me. See attached.

Not applicable
Author

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...