Extract Required inputs from Script Log files in a Directory

Aravindvunnam — Mon, 10 Apr 2023 10:42:05 GMT

Hello,

i am new to Qliksense , is there any possible way to create QVW to extract required information(Database connection /view, QVD, XLS ) from the LOG FILES in a Directory.

required information like : Database Connection/view, Qvd Storepath & Name , XLS

Example:

CONTRACT_EXTRA1:

20230405T061027.687+0000 0052 LOAD *

20230405T061027.688+0000 0053 SQL SELECT *

20230405T061027.688+0000 0054 FROM BI_DEV_ENVIRONMENT.BI_DEV_ALL.CONTRACT_EXTRA1

20230405T061107.438+0000 5 fields found: ROWNUMBER, NAME, DESCRIPTION_MLID, DESCRIPTION, REFERENCE,

20230405T061108.152+0000 82,420 lines fetched

20230405T061108.153+0000 0056 STORE CONTRACT_EXTRA1 INTO

lib://Data/QVD\PROD\CONTRACT_EXTRA1.qvd (qvd)

20230405T062028.790+0000 0056 FROM lib://Data/Excel\Metadata.xlsx

20230405T062028.790+0000 0057 (ooxml, embedded labels, table is ***)

20230405T062028.794+0000 2 fields found: Contract Status, Contract Status Desc,

20230405T062028.794+0000 42 lines fetched

20230405T061108.193+0000 0051 COST_DEV:

20230405T061108.193+0000 0052 LOAD *

20230405T061108.193+0000 0053 SQL SELECT *

20230405T061108.193+0000 0054 FROM BI_DEV_ENVIRONMENT.BI_DEV_ALL.COST_DEV

20230405T061325.771+0000 8 fields found: MARKET, LESSOR, MONTH, CONTRACTID, INVOICEDATE, CUM_ENDAMT,

20230405T061327.434+0000 83,234 lines fetched

20230405T061327.435+0000 0056 STORE AFI_UK_COST_DEV INTO lib://Data/QVD\UK_PROD\COST_DEV.qvd (qvd)

20230405T061327.481+0000 0051 CUSTOMER:

20230405T061327.481+0000 0052 LOAD *

20230405T061327.482+0000 0053 SQL SELECT *

20230405T061327.482+0000 0054 FROM BI_DEV_ENVIRONMENT.BI_DEV_ALL.CUSTOMER

20230405T061332.384+0000 3 fields found: CUSTOMERID, BUSINESSPARTNERREFERENCENUMBER, LIVEDATE,

20230405T061332.388+0000 1,791 lines fetched

20230405T061332.388+0000 0056 STORE CUSTOMER INTO lib://Data/QVD\PROD\CUSTOMER.qvd (qvd)

20230405T061332.392+0000 0051 CONTRACT:

20230405T061332.392+0000 0052 LOAD *

20230405T061332.393+0000 0053 SQL SELECT *

20230405T061332.393+0000 0054 FROM BI_DEV_ENVIRONMENT.BI_DEV_ALL.CONTRACT

20230405T061339.302+0000 2 fields found: CONTRACTID, EXCESSRATE,

20230405T061340.897+0000 83,340 lines fetched

20230405T061340.898+0000 0056 STORE CONTRACT INTO lib://Data/QVD\PROD\CONTRACT.qvd (qvd)

Thanks In Advance;

Thanks;

Aravind

@MarcoWedel can you please help me on this

Re: Extract Required inputs from Script Log files in a Directory

BrunPierre — Mon, 10 Apr 2023 11:43:35 GMT

Several functions can be used, notably WildMatch(), SubStringCount() and the Like operator.

As below.

LOAD *
FROM .../Logfile;
Where WildMatch(Field,'*Database Connection/view*','*Qvd Storepath & Name*','*XLS *') > 0 ;

Re: Extract Required inputs from Script Log files in a Directory

marcus_sommer — Tue, 11 Apr 2023 13:47:00 GMT

This is already a tool for it, see:

Search Recipes | Qlikview Cookbook

topic Extract Required inputs from Script Log files in a Directory in QlikView

Extract Required inputs from Script Log files in a Directory

Re: Extract Required inputs from Script Log files in a Directory

Re: Extract Required inputs from Script Log files in a Directory