Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satishgaba
New Contributor

Comparing two column

Hello,

I am new to Qlik sense and some help on comparing two column for match.

I have created one data module after joining two tables, and now, I want to compare two column of newly created data model and create new column under same data module with Flag, Yes/No based on match/unmatch condition.

For example- I have Table A and B which has two similar column A1 and B1 respectively,  I have created one Data module after Left join on these two tables containing both column A1 & B1.

Now, I want to compare these two column for each records and write a new column to Data model say C with Yes/No based on match/unmatch condition.

Thanks in Advance for help!

1 Reply
drillnaut
Valued Contributor

Re: Comparing two column

A simple If statement should suffice.

LOAD *,

If( A1 = B1, 'Yes', 'No') AS 'IsMatch'

;

LOAD * Inline

[

'A1','B1'

1 , 3

1 , 1

2 , 4

5 , 5

]

;