Hi,
Solved the problem. Maybe not according to best practice
Marketlist2:
load
DUEDATEYYYYMM_Export&text('_')&ENERGI_ORIGIN_Export&text('_')&EYC_Group_Export&text('_')&Customer_LANGUAGE_NAME_Export as Marketlistname,
ENERGI_ORIGIN_Export&text('_')&EYC_Group_Export as Campaigndefinition,
Customer_CODE_Export,
DELIVERYSITE_CODE_Export&text('_')&GRIDAREA_CODE_Export as Delsitecode_Gridcode
Resident tmpExportLink
where 1=1
and DUEDATEYYYYMM_Export <= $(vToday2)
;
Marketlist:
load
RowNo() as RowNumber,
Marketlistname,
Customer_CODE_Export,
Delsitecode_Gridcode,
Campaigndefinition,
1 as _tmponly
Resident Marketlist2
where 1=1
and WildMatch(Marketlistname, '201601_Mixed*')
order by Marketlistname
;
MinRowNumber:
load
Campaigndefinition as Campaigndefinition2,
min(RowNumber) as minRowNumber
Resident Marketlist
group by Campaigndefinition;
left join(MinRowNumber)
LOAD Campaigndefinition as Campaigndefinition2,
[Standardcontract 1],
[Standardcontract 2]
FROM
(ooxml, embedded labels, table is Sheet1);
left join(Marketlist)
load
minRowNumber as RowNumber,
[Standardcontract 1],
[Standardcontract 2]
Resident MinRowNumber;
drop Table Marketlist2;
drop Table MinRowNumber;
drop field Campaigndefinition;
drop field _tmponly;
drop Field RowNumber;
store Marketlist into Marketlist.csv (txt);
drop table Marketlist;
