topic To Match Records in App Development

To Match Records

Upali_Wijearatne — Tue, 12 Dec 2023 11:53:33 GMT

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

Re: To Match Records

Parthiban — Tue, 12 Dec 2023 12:01:36 GMT

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.

Re: To Match Records

Upali_Wijearatne — Tue, 12 Dec 2023 12:39:51 GMT

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

Re: To Match Records

Parthiban — Tue, 12 Dec 2023 12:59:22 GMT

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!