Hello @srchagas , I put my variables in string after in number but nothing works. I made the same request directly in Snowflake and they turned out fine…
Here is the odag variable initialization script:
IF '$(odagActive)' = '' THEN
TRACE ODAG variables not inserted, loading sample data;
SET 'odag_MOIS_ANNEE' = '''202305''';
SET 'odag_ARTICLE_CODE' = '''MODELE', 'PALPFN''';
SET 'odag_CODE_SITE' = '''0000001126''';
END IF;
SET 'preset_MOIS_ANNEE' = $(odag_MOIS_ANNEE);
SET 'preset_ARTICLE_CODE' = $(odag_ARTICLE_CODE);
SET 'preset_CODE_SITE' = $(odag_CODE_SITE);
And here I put the data loading script with the variables :
VENTES_DV:
LOAD
*;
SELECT
"Ticket_Caisse_Valide_Site_Identifiant" as "CODE_SITE",
RIGHT("Ticket_Caisse_Valide_Article_Code", 6 ) as ARTICLE_CODE,
"Calendrier_Mois_Code" AS MOIS_ANNEE,
sum("Ticket_Caisse_Valide_Montant_Ligne_Montant_NET") as FVTE_CA_PVP_TTC_NET,
FROM "DATASERVICE"."V_F_TICKET_CAISSE_VALIDE_LIGNES"
LEFT JOIN v_d_calendrier
ON to_date("Ticket_Caisse_Valide_Date_Enregistrement") = v_d_calendrier."Calendrier_Date"
WHERE (case
when concat($(odag_MOIS_ANNEE))='' then 1=1
else "Calendrier_Mois_Code" =
(SELECT MAX("Calendrier_Mois_Code")
FROM v_d_calendrier
WHERE "Calendrier_Mois_Code" IN ($(odag_MOIS_ANNEE)))
end)
AND (case
when concat($(odag_ARTICLE_CODE))='' then 1=1
else RIGHT("Ticket_Caisse_Valide_Article_Code", 6 ) in ($(odag_ARTICLE_CODE)))
end)
AND (case
when concat($(odag_CODE_SITE))='' then 1=1
else "Ticket_Caisse_Valide_Site_Identifiant" in ($(odag_CODE_SITE))
end)
GROUP BY 1, 2, 3;
thanks in advance
