Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
taz803
Contributor III
Contributor III

exlure data from sql file

hello ,i have a request tab1 had all teams  i want to exclure the CD_Equipe mentionned in the excel file .

excel.PNG

tab1:
NoConcatenate
select
DT_EVENEMENT,
Nom_EQUIPE,
CD_EQUIPE,
sum(sales) AS vente
from
tab1 , tab2
where

group by
DT_EVENEMENT,
Nom_EQUIPE,
CD_EQUIPE ;

exclusion:
LOAD
CD_EQUIPE,
DT_DEBUT,
DT_FIN
//LIB_EQUIPE_COURT
FROM [lib://AttachedFiles/exclu.xlsx]
(ooxml, embedded labels, table is [Exclusion Equipes]);

exclusion2:
NoConcatenate
Load
*
resident tab1;
inner join
IntervalMatch(DT_EVENEMENT,CD_EQUIPE)
load DT_DEBUT , DT_FIN , CD_EQUIPE
resident exclusion;

exclusion3:
NoConcatenate
load *
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 😞

Labels (6)
0 Replies