topic Re: Getting all active records merged in 1 record in QlikView

Getting all active records merged in 1 record

gaurav2017 — Fri, 20 Nov 2020 18:02:30 GMT

‌Is this possible what i want to achieve shown in this image.

in the image attached, the data shown above is the type of data i have in the table, and the data shown below in the image is what is requirement.

I thought it might be possible using the loop, but not able to get the correct output using loop.

Gysbert_Wassenaar — Sun, 24 Jan 2016 08:26:04 GMT

Please post a source table and the result table you expect. An excel file with examples for both tables (including data) will be fine.

maxgro — Sun, 24 Jan 2016 09:08:19 GMT

From your image it seems you need a (pseudocode)

load

[Employee Id],

max(Start),

max (End),

concat (distinct Type, ',')

resident yourtable

group by [Employee Id];

Thu, 11 Feb 2016 01:19:07 GMT

You can use the group by function to get the latest values.

LOAD

EmployeeID,

Max(Start) AS Start,

Max(End) AS End,

Concat(Distinct Type , ',') AS Type

From Source

Group By

EmployeeID

;