How do I merge the rows?

[Jens]

Hey,

I have the following table:

Person	date	time1	time2
bob	05-10-2021	2 min	-
bob	05-10-2021	-	5 min
roy	05-10-2021	1 min	-
roy	05-10-2021	-	6 min

Maybe you see the problem.. I want to have the data in one row and not in the displayed version. My result should look like these:

Person	date	time1	time2
bob	05-10-2021	2 min	5 min
roy	05-10-2021	1 min	6 min

I was trying lots of joins and concatenation functions, but nothing worked. I hope you can help me.

[AshutoshBhumkar]

Hello,

Could you provide any screenshot for those '-'.

We can remove those, If those are not relevant

[Jens]

@AshutoshBhumkar This is how my table looks like now:

You see that Qlik has joined the attribute time1 and time 2 in row2, but the rows with only time1 and time2 are preserved.

[AshutoshBhumkar]

Maybe you need to remove null values and then join.

[Jens]

Yes.. but if I do it, then the values other time values get deleted. I don't understand why the join is so strange. Normally in a SQL Join there are only the values, that could have been joined together, but in Qlik there is somehow a other comphrehension of a join..