topic Re: Compare two fields from two tables and get the value from another table in QlikView

Compare two fields from two tables and get the value from another table

Anonymous — Wed, 05 Nov 2014 17:07:31 GMT

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

Kindly suggest for this.

its_anandrjs — Wed, 05 Nov 2014 17:15:13 GMT

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

Anonymous — Thu, 06 Nov 2014 04:15:28 GMT

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.