Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be alias name for second table then use T1 as where you need
Applymap or Join might work.
Since the values are different in both the columns better to concatenate both the table columns are to alias as the same column names
Hello,
What is your required output??
concatenate or outer join will work for you..
Regards,
Prashant
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
.
.
.
Hi,
sorry to say but still not clear can you explain with sample data??
Regards
Better to share the sample data ,QVW and the required output so that it will helps to understand
Hi
FYI,
Table 1 is:
Table 2 is:
also post your required output.
Regards,