How to join two tables in IA

reddy.vinod · Post by **reddy.vinod** » Thu Oct 27, 2011 7:46 am

Hi,
I am new to Information Analyzer, i started working on column analysis, virtual columns and virtual tables.

I am facing one problem, I am trying to perform join on two tables and next column analysis on select fields. I am not able to join two tables while creating virtual tables. Could anyone please let me know process to join two tables.

Thanks in Advance...
Vinod.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 27, 2011 12:36 pm

If the two tables are in the same database you can create a view in that database consisting of the required join and perform column analysis on the view.

reddy.vinod · Post by **reddy.vinod** » Tue Nov 01, 2011 8:07 am

Thanks for the reply ray, if nothing works i would like to create views in database. I have little hope on datarules in IA, but i never used them. May i know, can we create datarules to join two tables and for column analysis.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 01, 2011 12:29 pm

No, that's not what data rules are about. Data rules are expressions that evaluate to true or false depending on the values in the data. Data rules use join key elements to specify the relationship between tables when you have a data rule such as tablea.columnx < tableb.columny (and there is a joinable relationship between the tables).

There is no capacity for joining tables to perform column analysis.

Tables are only implicitly joined when common domain (cross table) analysis is being performed; that is, you do not specify the join directly.

qt_ky · Post by **qt_ky** » Tue Jul 03, 2012 2:49 pm

Looking in the IA 8.7 User's Guide chapter 5 about analyzing columns, under the "Creating a virtual table" section, it says you can create a virtual table to segment data from one or more tables. Segmentation can be vertical or horizontal... I think the User's Guide is wrong. There doesn't seem to be any facility in the user interface to create a virtual table using more than one table. Has anyone noticed this? It may be time for a PMR...