topic Re: How does wild card work in script? in QlikView

How does wild card work in script?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How does wild card work in script?

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:40:39 GMT

Is that throwing any error?

Re: How does wild card work in script?

Anonymous — Wed, 06 Dec 2017 06:50:32 GMT

yes.

Re: How does wild card work in script?

prma7799 — Wed, 06 Dec 2017 06:51:53 GMT

what error you are getting

Re: How does wild card work in script?

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:56:12 GMT

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..

Re: How does wild card work in script?

avinashelite — Wed, 06 Dec 2017 06:57:13 GMT

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

Re: How does wild card work in script?

prashantsanchet — Wed, 06 Dec 2017 06:57:49 GMT

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

;

Re: How does wild card work in script?

its_anandrjs — Wed, 06 Dec 2017 08:09:21 GMT

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.

Re: How does wild card work in script?

Chanty4u — Wed, 06 Dec 2017 08:54:39 GMT

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

Re: How does wild card work in script?

Anonymous — Wed, 06 Dec 2017 11:57:05 GMT

Re: How does wild card work in script?

Anil_Babu_Samineni — Wed, 06 Dec 2017 12:01:53 GMT

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

Re: How does wild card work in script?

Anonymous — Wed, 06 Dec 2017 12:04:26 GMT

now how to apply wild card in this?

Re: How does wild card work in script?

Anil_Babu_Samineni — Wed, 06 Dec 2017 12:08:56 GMT

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

Re: How does wild card work in script?

Anonymous — Wed, 06 Dec 2017 12:32:16 GMT

its similar to like in database.

Re: How does wild card work in script?

Anonymous — Wed, 06 Dec 2017 13:26:19 GMT

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

Re: How does wild card work in script?

Anonymous — Thu, 07 Dec 2017 04:46:35 GMT

Yes I have

Re: How does wild card work in script?

Anil_Babu_Samineni — Thu, 07 Dec 2017 05:04:26 GMT

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

Re: How does wild card work in script?

Anonymous — Thu, 07 Dec 2017 05:21:26 GMT

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

Re: How does wild card work in script?

Anil_Babu_Samineni — Thu, 07 Dec 2017 05:36:02 GMT

Do you something related field Year in your FTP Server?

Re: How does wild card work in script?

jonathandienst — Thu, 07 Dec 2017 06:01:19 GMT

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.