Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

fusionner valeurs champ

Bonjour,

je voudrais fusionner deux valeurs d'un champ pour obtenir une seule valeur

Champ Fille d'attente:

N1-Annuaire

N2-Certificats  -> N2-Certificats

N2-Certificat ->  N2-Certificats 

N3-Carte

j'ai utilisé la fonction peek match ma ça ne fonctionne pas.

Merci

Maurice

2 Replies
rahulpawarb
Specialist III
Specialist III

As a workaround, you can make use of Mapping Load & ApplyMap functionality (refer below given sample code):

Map_FieldName:

Mapping LOAD * INLINE [

FieldName, FieldDesc

N2-Certificats, N2-Certificats

N2-Certificat, N2-Certificats

];

Data:

LOAD ApplyMap('Map_FieldName', FieldName) AS FieldName INLINE [

FieldName

N1-Annuaire

N2-Certificats

N2-Certificat

N3-Carte

];

Hope this will be helpful.

Regards!

Rahul Pawar

MauriceLudo
Creator II
Creator II
Author

Thank you Rahul,

'Fille d'attente' is th field not table and

N1-Annuaire

N2-Certificats  -> N2-Certificats

N2-Certificat ->  N2-Certificats

N3-Carte

is the values of the field