load from the CSV file, the data containing duplicate lines except the value in the last column

[#1]

Hi guys! Help the beginner)) I need to load from the CSV file, the data containing duplicate lines (in the attachment example) except the value in the last column. What is the use of the function so that for the same values of the columns from 1 to 4, one line was formed, and the value from column_5 was the last one or any?

[ahaahaaha · Accepted solution]

Hi,

As variant (in attached files)

Directory;

LOAD DISTINCT

    Col_1,

    Col_2,

    Col_3,

    Col_4,

    Max(Col_5)

FROM

[33.xlsx]

(ooxml, embedded labels, table is Лист1)

Group By Col_1, Col_2, Col_3, Col_4;

Regards,

Andrey

[#3]

Thank you so much!