When I am trying to load a master file using a wild card match(Master_*.xlsx) its giving error
For eg-
Material_Master:
Load
Material,
COLOR,
SIZE,
Material&COLOR&SIZE as itemnumber,
[Size Group],
Description,
Compostion,
BRANDCODE,
BRAND,
Season,
Theme,
[Delivery Code],
Gender,
IF(Gender ='LADIES', 'WOMEN', IF(Gender='MENS','MENS', IF(Gender='BOYS' or Gender='GIRLS' or Gender='BABY','KIDS', Gender))) as Gender_Revised,
[Product Hierarchy],
[Material Group],
[Core/Fashion],
Fit,
Pattern,
[Key/NonKey],
Range,
Origin,
[Top/Bottom],
Sleeve,
[Neck/Collar],
Weather,
Occassion,
[Custom Description],
[Material Grp4 Code],
[Material Grp4 Description],
EAN13,
[ALTERNATE EAN],
[Purchase Group],
[Purchase Group Description],
[Basic Data Composition],
[Material Type],
Promotional as Promotional_1,
[MRP(INR)] as MRP_INR,
Cost,
if ([MRP(INR)] <1000, '<1000', if ([MRP(INR)] <2000, '1000-2000',if ([MRP(INR)] <3000, '2000-3000',if ([MRP(INR)] <4000, '3000-4000',if ([MRP(INR)] <5000, '4000-5000',if ([MRP(INR)] <6000, '5000-6000', '>6000')))))) as [MRP Bucket]
FROM
(ooxml, embedded labels, table is Sheet1);
