how to maintain relation

[maniram23]

Hi experts,

I have two tables. there is no common fields. how to maintain the relationship between those two tables?

[robert_mika]

No common field or common field name?

Id the first use CONCATENATE

tab1:

Load col_a, col_b, col_c from ...;

Concatenate (tab1)

Load col_b, col_x, col_y from ...;

if the second change one of the filed name using AS

[maniram23]

Hi Robert Mika,

Thanks for giving fast response .

there is no common field names.

[vardhancse]

With out common field we can not join any tables,if there is no common field try to create one field using some autonumber() in both the tables so that they will join based on the new field.

[vardhancse]

Hi,

Using concatenate we can do it but its not preferred because the volume of dashboard will be very huge as there is no common filed concatenation will lead to result like below

Field1   Field2

1          -

2          -

-          3

-          4

[robert_mika]

Use CONCATENATE..

[qv_testing · Accepted solution]

Hi Ram,

If you don't have any common field.

Use Concatenate.

if you want to store 2 tables into one table.. better to use Cancatenate.

Example:

Select * from Table1

Concatenate

Select * from Table2

Otherwise, create one key Autonumber() or RowNo() in both tables. then will join based on the New Key.