Discussion Board for collaboration regarding Qlik DataMarket.
I am trying to find a way to exclude some rows.
If I have a duplicate in one column, I need to identify a specific name in another column and exclude the remaining rows.
Column A has the same email address but in column B it is for different products. I am specifically looking for ProductA and would need to exclude the rows for ProductB and ProductC.
However, there will be situations where I have the same email address multiple times where the productA will not exist. I will need to keep all of those rows.
Is this possible to do in QV?
Go to Solution.
May be something like this:
LOAD * Inline [
Left Join (Table)
ColumnB as NewColumnB
Where ColumnB = 'ProductA';
LOAD DISTINCT *;
If(Len(Trim(NewColumnB)) > 0, NewColumnB, ColumnB) as ColumnB