How to join such rows

[Katarzyna_Orlowska]

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 · Accepted solution]

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]

Bingo. Thank you.