Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

agnie_john
New Contributor II

Check Duplicate values in Column

Hi,

I have  a table with duplicate values in on column.

I need to do some logic for duplicate records.

this is my table

 

ItemQtyCost
Item11100
Item11101
Item11100
item21200
item32

300

This the Output i need. 

ItemQtyCostDuplicateRevised Qty
Item11100No1
Item11101Yes0
Item11100Yes0
item21200No1
item32300No2

How to do this using load script or set analysis?

Thanks,

John.

1 Reply
sasikanth
Valued Contributor III

Re: Check Duplicate values in Column

HI

Check this,

LOAD *, if(Item=Peek(Item) and Qty=Peek(Qty),0,Qty) as RevisedQty;

load * Inline [

Item Qty Cost

Item1 1 100

Item1 1 101

Item1 1 100

item2 1 200

item3 2 300

] (delimiter is \t);

Community Browser