How does wild card work in script?

[Anonymous]

Hi

is this syntax correct ? The text marked in bold is used as wild card but its not working why?

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);

[Anil_Babu_Samineni]

Is that throwing any error?

[Anonymous]

yes.

[prma7799]

what error you are getting

[Anil_Babu_Samineni]

Okay, What ever you are showing is absolutely correct accord to me. But, When we load using * it has multiple sheets involved where we are looking. So, I believe the format of schema and/or data structure should be same like field names extra..

[avinashelite]

I think all the files doesn't have the same structure ....check the sheet names and columns once

[prashantsanchet]

Hope this will help.

Set vFolder = 'D:\Data\Master';

Load

aterial,
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

$(vDirectory)\Master_*.xlsx

;

';

[its_anandrjs]

Here wildcard * means loading all file that are start with Master..... and file extension should be *.xlsx and the sheet name should be Sheet1 also folder location should be same D:\Data\Masters\. So please check all this ok.

[Chanty4u]

can you share the screen shot of the excel filenames in the folder where you are extracting?

[Anonymous]