Extracting source table name from log file

[adarsh_a]

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 ?