Extract Required inputs from Script Log files in a Directory

[Aravindvunnam]

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

[BrunPierre]

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 ;

[marcus_sommer]

This is already a tool for it, see:

Search Recipes | Qlikview Cookbook