Extracting source table name from log file

adarsh_a — Mon, 11 Aug 2014 07:28:09 GMT

Hi All,

I have a requirement to extract the table name used in qlikview and source table name associated with it from log file.

Eg: Suppose I have data like this ..

sample:

LOAD * Inline [

Field

t1:

SELECT CityId,

CountryID,

RegionID,

City,

Latitude,

Longitude,

TimeZone,

DmaId,

Code

FROM

table1

t2:

SELECT CityId1,

CountryID1,

RegionID1,

City1,

Latitude1,

Longitude1,

TimeZone1,

DmaId1,

Code1

FROM

table2

];

My expected results : target table name , Source table name

t1 , table1

t2 , table2

how to do this ?

topic Extracting source table name from log file in QlikView