How to join 2 QVD with same column Name

[Sundeep]

Hi All,

I have 2 qvd's (QVD 1 and QVD2) with below structure

Table1:

Load C1, C2, C3 from QVD1;

Table 2:

Load C1, C2, C4 from QVD2;

Now if I want to do left join then where should I specify on which column join should happen. In this case 2 column are same C1 and C2 but I want join these two QVD only on column C1.

Is it possible? please suggest how to achieve this

Thanks

[Channa]

To avoid join on C2 add alias name to C2 as C21

Just put left join between two tables

[jonathandienst]

Aiias the name of one or both C2 fields to different names, for example:

Table1:
Load C1, C2 as T1.C2, C3 from QVD1;

Join (Table1)
Load C1, C2 as T2.C2, C4 from QVD2;

[Sundeep]

Is there any way we can see  or validate on what columns joins have been created? 

If there are 15 column in a table and 10 column have same name then we need to rename all 10 columns? Is there any work around for this?