Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ;
This is already a tool for it, see: