Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello, Bob.
What are:
Jouet
Cadeaux
Décoration
Toys
Gift
Decoration
?
Is it name of fields or it's values of field Items?
It doesn't make any sens.
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
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
...
;
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 ???
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
...
;
still the same problem.... even when I added the key word MAPPING...
Works for me. See attached.
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...