Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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