topic Re: How to join such rows in QlikView

How to join such rows

Katarzyna_Orlowska — Mon, 02 Mar 2026 13:39:52 GMT

Hello everyone

I have one big external table with such structured data:

Order,Date 1 ,Value_New, Value_Old, Date_New, Date_Old

4566,01.01.2026 , 80,-,02.2026,-

4566,01.01.2026,-,60,-,12.205

and so one....

two rows with one Date1 and one Order tells me how amount was changed (old, new) and what is the new time od delivery (old, new).

I get this data in load script and I want to have one! row with columns:

Order,Date 1 ,Value_New, Value_Old, Date_New, Date_Old

Please could you give me a hint witch functions use to get such result?

Thank you in advance!!

Vegar — Tue, 03 Mar 2026 05:55:33 GMT

If you know the structure as you describe it, then you could probably just load and aggregate over the common dimensions.

Load

Order,

[Date 1] ,

only(Value_New) as value_new,

only(Value_Old) as value_old,

only(Date_New) as date_new,

only(Date_Old) as date_old

From the_source

Group by Order, [Date 1];

Katarzyna_Orlowska — Tue, 03 Mar 2026 10:26:04 GMT

Bingo. Thank you.