Qlikview Script

[Anonymous]

Friends,

I'm having the below table,

In this table, when the customer name is same it should have only one unique customer ID. For example the customer 'Addivant' should have only one unique customer ID but it has two IDs in the above table.

Please help how to achieve this in Qlikview script. Thanks in advance.

[Anonymous]

How about using Min(CustomerID) while doing a group by Customer name??

[Anonymous]

Yes Shiva, I have tried this but getting the below error script message.

[Anonymous]

You cant use non aggregated fields in the load statement which are not present in group by clause.

[Anonymous]

Plz help me how to achieve this Shiva.

[brentdej]

Try change the group by statement to:

group by Customer_Name, Customer_Type, [Source Format], [Destination Format];