Try this script
MaxString(SupplierName) AS SupplierName,
FROM [http://community.qlik.com/thread/107248] (html, codepage is 1252, embedded labels, table is @1)
GROUP BY SupplierCode, InvoiceNo;
Hope it helps you.
Hi Shashank, You can remove there duplicates by "Exists" function.
If the Invoice is unique among these three fields then try like below:
Load SupplierCode , SupplierName , InVoiceNo
where not Exists(InvoiceNo) ;
If the Invoice No is same for different SupplierCode then try like below:
Load * where not exists(Key);
Load SupplierCode , SupplierName , InVoiceNo , SupplierCode & InVoiceNo AS Key
From sourcetable ;
Please find the attached file for reference.
Comm107248.qvw 148.5 K
This is my suggestion
MinString(SupplierName) as SupplierName,
Group By SupplierCode,InvoiceNo;
i would say load first your table without supplier names
then maintain another one with supplier names and codes like
LOAD code, name from table where not exist(code)
BEWARE code field has to NEVER be loaded before even in an other table under same name
ELSE start by loading this table first