Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello ,i have a request tab1 had all teams i want to exclure the CD_Equipe mentionned in the excel file .
tab1:NoConcatenateselect DT_EVENEMENT, Nom_EQUIPE, CD_EQUIPE,sum(sales) AS ventefrom tab1 , tab2 where
group by DT_EVENEMENT, Nom_EQUIPE, CD_EQUIPE ;
exclusion:LOADCD_EQUIPE,DT_DEBUT,DT_FIN//LIB_EQUIPE_COURTFROM [lib://AttachedFiles/exclu.xlsx](ooxml, embedded labels, table is [Exclusion Equipes]);
exclusion2:NoConcatenateLoad*resident tab1;inner join IntervalMatch(DT_EVENEMENT,CD_EQUIPE) load DT_DEBUT , DT_FIN , CD_EQUIPEresident exclusion;
exclusion3:NoConcatenateload *resident exclusion2 where isnull(DT_DEBUT);
i wrote this code but it doesn't function the 0555, 0556 ,0888 still here !!!
can someone help me 😞