1 Reply Latest reply: Feb 26, 2018 11:52 AM by Justin Dallas RSS

    Comparing two column

    Satish Gaba

      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!