To Match Records

[Upali_Wijearatne]

Hi Friends,

I have two tables with data as shown below

Here I want to find the code in Column D of Table 2 from Column A in the Table 1 and pull the amount (Column B) and record that amount against matching record in Column F of the Table 2. I have tried Apply Match command but with no success please. Kindly advice me how to solve this issue

[Parthiban]

Hi,

Use KeepChar function in column A. The result of column A is only numbers, and then link the column A and D in two tables. Finally you got the amount against code in table 2.

[Upali_Wijearatne]

Thanks. But since I am new to qlikview pls elaborate it a little with an example.

[Parthiban]

Try this one,

Table1:

Load 

keepchar(Description,'0123456789') as Key,

    Amount

from File Path;

Table2:

Load 

Code as Key,

    Description

from File Path;

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!