Supplier_Category as Partners,
Max(1) as Temp
Group By Supplier_Category
Supplier_Category = 'Company A' or
Supplier_Category = 'Company B' or
Supplier_Category = 'Company B'
Any addtional fields added in to the Load statement must also be added to the group by statement.
Thanks for your prompt response.
I think I probably didn’t explain clearly what I wanted. I still want the field to be called Supplier_Category but I need to group/categorise/rename certain values (Company A, Company B, etc) within the field as ‘Partners’.
((Supply_Category)='Company A', & if(Supply_Category)='Company B') as Partners
Is this possible in the load script?