join between two data sources
I am currently evaluating log parser. is it possible to join data between two different data sources. i.e. IIS query that joins with sql data source. if so, can you point me in the right direction.
ja
shared this idea
In Log Parser Lizard version 5.0 new keywords are introduced to merge, join, group queries (these can be very useful since the merged datasets can be used in Dashboards and Reports):
GO – create tables in single dataset without relation (useful in dashboard and reports)
MERGE – merge tables in one
LPL_UNION – same as MERGE
LPL_INTERSECT – intersection of two tables
LPL_PRODUCT – product of two tables
RELATION_ON_FIRST_COLUMN – create tables in single dataset and try to create a relation on first column (must be of same data type)
RELATION_ON_SAME_COLUMNS – create tables in single dataset and try to create a relation on all columns with same name
JOIN_ON_FIRST_COLUMN – joins results of two tables in another one on the first column
JOIN_ON_SAME_COLUMNS – joins tables on the columns with the same name