Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need one help.
Requirement : We have two columns from two different tables like the example given below.
If i will serach for ABCDS in column 1 ,then it should return all the values in column2.
So we need to compare the two columns from table1 and retrieve another value from table2 .
Example : TABLE1: column1 column2
ABCDS ABCDS 0.5GHND
ABCDS 0.1GHNDgs
TABLE 2 : value
20
Kindly suggest for this.
Try with
TABLE1:
Load
column1,
column2,
If(column1 = Left(column2,5),1,0) as CompareFields
From Source;
Bu this you get on Field with data 1 and 0 1 means that row is compared
And what is the use of second table let me know do you have any common field in table 2
Regards
Anand
Sorry,,Just a small correction
Column 1 is from TABLE 1 and Column 2 is from TABLE 2.
And Value is from another table TABLE 3 and there is no common filed in TABLE 3.