topic Re: Read the string from text in QlikView

Read the string from text

ajaykumar1 — Tue, 04 Aug 2015 11:43:42 GMT

Hi All,

I hope all are doing good.

I have a requirement to read the start and end time of batch jobs and store in qvd. For this I need to get the task name from text and call into table, and store into qvd. Example: In below script text is $(Include=D:\script\create_order.qvs). I need to get the "create_order" as the task name and call into "Sales" table then store into qvd.

LET vStartTime = Now();

$(Include=D:\script\create_order.qvs)

LET vEndTime = Now();

Sales:

LOAD

'create_order' AS ReloadTable,

'$(vStartTime)' AS StartTime,

'$(vEndTime)' AS EndTime

AutoGenerate (1);

LET vStartTime = Now();

$(Include=D:\script\derive_order.qvs)

LET vEndTime = Now();

Sales:

LOAD

'derive_order' AS ReloadTable,

'$(vStartTime)' AS StartTime,

'$(vEndTime)' AS EndTime

AutoGenerate (1);

Hope you understand requirement. let me know if you need any information.

Thanks

Ajay

Re: Read the string from text

jonathandienst — Tue, 04 Aug 2015 12:01:21 GMT

What is your question? You appear to have done everything except:

You need a Concatenate LOAD statement to get the log file history from the qvd

and a 'STORE Sales' statement to save the updated log file.

Re: Read the string from text

Kushal_Chawda — Tue, 04 Aug 2015 12:16:24 GMT

what is the problem statement?

Re: Read the string from text

ajaykumar1 — Tue, 04 Aug 2015 12:19:50 GMT

Hi Jonathan,

I don't want to write "create_order" or "derive_order" in Sales table, it should automatically read from the texts $(Include=D:\script\create_order.qvs),.....

then i will concatenate these tables ans store into qvd.

Re: Read the string from text

sorrakis01 — Tue, 04 Aug 2015 12:27:46 GMT

HI,

You can create a Bucle... to read all qvds.

And the the file will be the name.

For each File in filelist ('c:\directory\'

LOAD $(File) as Name .......

next File

Regards

Re: Read the string from text

sasiparupudi1 — Tue, 04 Aug 2015 12:27:58 GMT

set vFilePath='D:\script\create_order.qvs';

let vFileName=subfield(TextBetween('$(vFile)','\','.'),'\',-1);

LET vStartTime = Now();

$(Include='$(vFilePath)');

LET vEndTime = Now();

Sales:

LOAD

'$(vFileName)' AS ReloadTable,

'$(vStartTime)' AS StartTime,

'$(vEndTime)' AS EndTime

AutoGenerate (1);

HTH

Sasi

Re: Read the string from text

sasiparupudi1 — Tue, 04 Aug 2015 12:42:17 GMT

set i=0;

set vConcatenate='';

sub GetFileNames(DirName,extension)

for each FoundFile in filelist(DirName & extension)

if i>0 then

let vConcatenate='Concatenate';

End if

let i=i+1;

let vFileName=subfield(TextBetween('$(FoundFile)','\','.'),'\',-1);

LET vStartTime = Now();

$(Include='$(vFilePath)');

LET vEndTime = Now();

Sales:

Load

'$(vFileName)' AS ReloadTable,

'$(vStartTime)' AS StartTime,

'$(vEndTime)' AS EndTime

AutoGenerate (1);

next FoundFile

end sub

Call GetFileNames('D:\script\','*.qvs');

Re: Read the string from text

sasiparupudi1 — Wed, 05 Aug 2015 13:01:35 GMT

Did you manage to solve your problem?

Sasi