Data load editor problems-Adding new rows from another table
Hi dear all, I have some problems when I am using data load editor.
I have a Table A, which have several columns, here are some fields:
Response_No, Client, Event, Q1,Q2,Q3,Q4,Q5
1, city council, training, 1,2,3,2,3
2, city council, training, 2,3,4,5,1
3, city council, training, 2,3,4,2,1
Another table is Table B, fields are :
Client, Event, Engagement,No of respondent,
For table B, it has some historical data inside, now I want to add rows into table B, the source of data come from table A,
For example, according to the data we have in table A right now, the new row in table B will be :
Client, Event, Engagement, No of respondent
city council, training, Avg(Avg(Q1) to Ave (Q5)), Count (Response_No) Group by Client,
Table A is updated weekly, so every time when we update the table A, similar rows will be added into table B. I am not sure how to achieve this in Qlik sense cloud or whether this function can be achieved, does anyone have some ideas??