I have a requirement which says to remove the duplicates from the column - "Bill to Customer Name and Customer Part Number" and then load the data. I tried to wrote the below code but it didn't work form. Can you help me with the code. Attach is the excel sheet.
LOAD Distinct *
FROM [lib://Documents/ODS.SIS.MKT.00019 - Open Quote Details (1).xlsx]
(ooxml, embedded labels, table is Sheet1) Where NOT Exists([Customer Part Number],[Bill To Customer Name]);
I understand that every row has different values and if I'm putting distinct then its gonna fetch all the 6 rows. So here in this case, ideally I should not use distinct. But my actual goal is to load the data and put the filter on ([Customer Part Number],[Bill To Customer Name]) so that I can remove the duplicated data. How can I achieve this?