Table/Data Organisation / merge sum field to table

[segerchr]

Hey, maybe you techs could help me by coding some sheets.

My goal is to have the pausedMinutes from table 1 in table 2. It could be that there is more than one actionID Pause, so i have to sum the pause minutes in table 1. After that, we can save it in table 2. 

I don't know how to do this. Maybe someone could help. 

Thanks 

[timpoismans · Accepted solution]

Table2:
LOAD
    TicketNummer,
    ID1
FROM [lib://Qlik Community/2.xlsx]
(ooxml, embedded labels, table is Sheet1);


Left Join (Table2)
LOAD
    TicketNummer,
    Sum(Pause)
FROM [lib://Qlik Community/1.xlsx]
(ooxml, embedded labels, table is Sheet1)
Group By TicketNummer;

Check this out if you will and see if it works as you intended.

Regards,

Tim P. 

[segerchr]

Thanks, that helps.