Qlikview Help

[#1]

Dear All,

I want to help in Qlikview.

1) The excel Auto Save in a Folder every day and qlikview every day load the excel file.

2) 20140325AAL it is my excel. how i insert 2014= Year, 03= Month, 25= day, than AAL= Factory Name= AAL Auto Create in Qlikview.

[AbhijitBansode]

Use Subfield(filebasename(),'_',1) as Source to get whole filename. then you can string functions on it get desired fields. Like :

Left(Subfield(Filebasename(),'_',1),4) as Year

Right(Subfield(Filebasename(),'_',1),3) as Factoryname

and on...

[its_anandrjs]

In excel sheet you want to insert the 2014= Year, 03= Month, 25= day, than AAL= Factory Name= AAL, Or in the Qlikview you want.

Regards

Anand

[#4]

Thank's please sent a example.

[#5]

Thank's Please sent a example.

[anbu1984]

Load *,Left(FileNm,4) as Year,Mid(FileNm,5,2) as Month,Mid(FileNm,7,2) as Day,PurgeChar(FileNm,'0123456789') As FactoryNm;

LOAD Factory,

     AAL,

     F3,

     filebasename() as FileNm

FROM

[20140325AAL.xls]

(biff, embedded labels, table is [20140325AAL$]);

[its_anandrjs]

Try this below load script and but let me know from excel sheet you want to read to the Qlikview

LOAD Factory,

     AAL,

Left(Filebasename(),4) as Year,

Mid(Filebasename(),5,2) as Month,

Mid(Filebasename(),7,2) as Day,

Right(Filebasename(),3) as Factoryname,

FileBaseName() as Name

FROM

[20140325AAL.xls]

(biff, embedded labels, table is [20140325AAL$]);

Regards

Anand

[#8]

Thank's for your nicely cooperation but I am extremely sorry for your

valuable time wastage.

I want to Qlikview auto load the excel file every day 3:00Pm and auto

create date every day and auto create factory.

On Fri, Oct 31, 2014 at 12:53 PM, anbu cheliyan <qcwebmaster@qlikview.com>

[#9]

See the attatchment

[#10]

Hii

Field:20140325AAL

Left(field,4) as year

mid(field,5,2) as month

mid(field,7,2) as day

right(field,3) as  Factory Name