Discussion Board for collaboration on QlikView Scripting.
In my model i have following fields:
My result table:
What i need: Get result table, which has no dublicate rows by Customer_Id:
Is it possible?
Model and source file in attachment.
Go to Solution.
rowno() as rn,
(ooxml, embedded labels, table is Sheet1)
load *, RowNo();
load Id, Customer_id, Name, Main_field
where Customer_id <> Peek(Customer_id)
order by Customer_id, rn;
DROP Table Table;
You can't use both DISTINCT & ROWNO() in same load statement.
Hi Try like Below:
FROM Test.xlsx (ooxml, embedded labels, table is Sheet1) ;
LOAD RowNo() , * Resident Temp;
DROP Table Temp;
For what i wrote this post:
my task is to concat different names for my Id.
Concat(Name,'-') as NewName
Group by Id;
In result i get NewName Name1-Name1-Name2-Name2, but i need: Name1-Name2
Use Distinct Qualifier Inside Concat function like below:
Concat(DISTINCT Name,'-') as NewName
it's what i need.