Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
afguillard
Contributor III
Contributor III

Erreur syntaxe au chargement d'un script

Bonjour,

Suite au chargement de ce script :

Packs:

LOAD [Distinct]

Commande as Commande1,

AnnéeSiteIndicatif as AnnéeSiteIndicatif1,

`Code Produit` as `Code Promo`

resident Ecommerce

WHERE Match(`Code Produit`, 'PACK_REUSS', 'PACK_AVAN');

J'ai le message d'erreur suivant :

Erreur de syntaxe, FROM manquant ou mal placé :

Packs:

LOAD [Distinct]

Commande as Commande1,

AnnéeSiteIndicatif as AnnéeSiteIndicatif1,

`Code Produit` as `Code Promo`

resident Ecommerce

WHERE Match(`Code Produit`, 'PACK_REUSS', 'PACK_AVAN')

Packs:

LOAD [Distinct]

Commande as Commande1,

AnnéeSiteIndicatif as AnnéeSiteIndicatif1,

`Code Produit` as `Code Promo`

resident Ecommerce

WHERE Match(`Code Produit`, 'PACK_REUSS', 'PACK_AVAN')

Pouvez-vous m'aider ?

Merci

Anne

1 Solution

Accepted Solutions
6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

[Distinct] is a field or you need all the distinct records?

If it is not a field, the right syntax is:

LOAD Distinct

Commande as Commande1,

AnnéeSiteIndicatif as AnnéeSiteIndicatif1,

`Code Produit` as `Code Promo`

resident Ecommerce

WHERE Match(`Code Produit`, 'PACK_REUSS', 'PACK_AVAN');

without [  ]

Please let me know.

afguillard
Contributor III
Contributor III
Author

Thanks a lot !

It works but there is still a problem : It doesn't load the packs nammed "PACK_AVAN" .

Do you know why ?

Anne

maxgro
MVP
MVP

try with

WHERE WildMatch(`Code Produit`, 'PACK_REUSS', '*PACK_AVAN*');

afguillard
Contributor III
Contributor III
Author

Thanks. It's ok with your syntax.

And if there is another pack to select :

WHERE WildMatch(`Code Produit`, 'PACK_REUSS', '*PACK_AVAN*','*PACK_ESSEN*');

Is it correct ?

Anne

alexandros17
Partner - Champion III
Partner - Champion III

Yes

pgrenier
Partner - Creator III
Partner - Creator III

Ou encore très simplement pour récupérer de façon générique tous les PACK

WHERE WildMatch([Code Produit], 'PACK_*');

Cordialement,

Philippe