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 ?