Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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?

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

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

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

2 Replies
ahaahaaha
Honored Contributor

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

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

Not applicable

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

Thank you so much!

Community Browser