topic Re: load from the CSV file, the data containing duplicate lines except the value in the last column in QlikView

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

Tue, 18 Apr 2017 12:21:16 GMT

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?

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

ahaahaaha — Tue, 18 Apr 2017 13:51:56 GMT

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

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

Tue, 18 Apr 2017 14:25:30 GMT

Thank you so much!