Duplicate rows for the same day (Concatenation)

[MassicotPSCU]

Hi,

I have concatenated two tables together. One with sales and one with sales per hour. The records are of these sales and sales per hour are day to day. My issue is that I have duplicate days now, one for sales and one for sales per hour. I would like to have just one row worth of data for each day. Is there a fix for this or is that how Qlik Sense just does things?

[sandeep-singh]

I would say use applymap function instead of the Concatenation. Below is the qlik community post for your reference.

https://community.qlik.com/t5/Design/Don-t-join-use-Applymap-instead/ba-p/1467592