topic Re: matching data from two different tables in App Development

matching data from two different tables

Bharathi09 — Tue, 27 Dec 2022 03:45:26 GMT

Hi All,

I have two different tables

Table1:

load

Code,

salary,

ID,

Name

From ();

Table2:

Code1,

DOJ,

DOL,

Age

From();

I want to see that data from Table2 'code1' matches with data from Table1 'code'

if matches it should give that matching data in another field as Code_data

if not matches it should give NA

Re: matching data from two different tables

anat — Tue, 27 Dec 2022 06:03:56 GMT

@Bharathi09 ,can you give a try using Applymap function.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/MappingFunctions/ApplyMap.htm

Re: matching data from two different tables

sidhiq91 — Tue, 27 Dec 2022 07:24:51 GMT

@Bharathi09 A simple left join can work as well.

Table1:

load

Code,

salary,

ID,

Name

From ();

left join (Table1)

Table2:

Code1 as code,

DOJ,

DOL,

Age

From();

Noconcatenate:

Table3:

Load

if(isnull(Code),'N/A',Code) as Code,

salary,

ID,

Name,

DOJ,

DOL,

Age

Resident Table1;

Drop table Table1;

If this resolves your issue, please like ad accept it as a solution.

Re: matching data from two different tables

Bharathi09 — Wed, 28 Dec 2022 11:11:44 GMT

No it's not working

I need to check firstly the data from first table Code1 is matching with data from 2nd table Code2 if matches mark the matching data from code2 as in new field Code, otherwise N/A