Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fjmontes
Contributor
Contributor

Concatenate 2 tables after apply Group by one

Hello,

Im using Qlik Sense and I don't have easy access to delete wrong created qvd. I want to concatenate 2 table but I have to group by 1 before the concatenate, the table that I have to group is reading a Sharepoint list with the status of some project and the oder table have the reading from previous days already group. Mi question is if the following statement work or I have tu group by the table and then use resident

LOAD
A,
B
From Previus_qvd

Concatenate

LOAD
A,
Sum(C) as B
From xxx
Group by A;

Store in Previus_qvd

Labels (1)
1 Reply
PhanThanhSon
Creator II
Creator II

Hi,

The syntax is incorrect, but the main idea can be implemented like this.

best regards Son