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]

As i mention earlier, this could be the reason due to fields are not constant. So, You may share atleast 2 sheets which is having real data we may hep for you

[Anonymous]

now how to apply wild card in this?

[Anil_Babu_Samineni]

What you mean by WildCard? Can you reply to same to whom you are contacting, Please?

[Anonymous]

its similar to like in database.

[Anonymous]

I think you are loading data from FTP server, do you have the credentials for that connection

[Anonymous]

Yes I have

[Anil_Babu_Samineni]

Because, when we talk about Wildcard? But, In your image there is no concept script related the same. can you explain little more related the business

[Anonymous]

I have material master which contains data based on different seasons, like for eg i want to cuurently use master of current season ie 2017 but once the season gets changed ie 2018 then i need to again use that file which will be present on ftp as MAT_Mas2018

[Anil_Babu_Samineni]

Do you something related field Year in your FTP Server?

[jonathandienst]

The FTP protocol does not support a wildcard load like that. Nor does FTP support For Each ... in FileList().

To loop over multiple files on an FTP server, you can get a list of the files and save them in a text file using an external bat file, then load the text file and loop over the files there. Alternatively either manually or using an external bat file, copy the files from the FTP server to a local folder or share, and then load them from there.