Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aravindvunnam
Contributor II
Contributor II

Extract Required inputs from Script Log files in a Directory

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

Labels (3)
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

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