How to combine two fields from two different table

[#1]

Hi Every one,

I have two tables Like T1, T2. These two tables contains same fields but different values i.e.,

Ex:

T1

A

C

E

AND

T2

B

D

F

So, i need to use T1 table values in T2.

My question is how to use T1 values in T2 Table?

[Anil_Babu_Samineni]

May be alias name for second table then use T1 as where you need

[MindaugasBacius]

Applymap or Join might work.

[avinashelite]

Since the values are different in both the columns better to concatenate both the table columns are to alias as the same column names

[PrashantSangle]

Hello,

What is your required output??

concatenate or outer join will work for you..

Regards,

Prashant

[#6]

Hi,

In my requirement is in that two table i haven't mention ID. Actually in that two tables one common ID column is there, I am using. Qualify and Unqualify. Why because as per my requirement i need to use first table T1 table and creating sum values, and by using  T2 table also. So I need to use two files for different requirements. In this situation I need to use  T1 table value i.e A value use in T2.

So how to use A value in T2 table

EX:

Qualify *;

Unqualify Id;

Load T1

.

.

.

Load T2

.

.

.

[PrashantSangle]

Hi,

sorry to say but still not clear can you explain with sample data??

Regards

[avinashelite]

Better to share the sample data ,QVW and the required output so that it will helps to understand

[#9]

Hi

FYI,

Table 1 is:

Table 2 is:

[PrashantSangle]

also post your required output.

Regards,