Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
MCFH93
Contributor III
Contributor III

Add New Row to Existing Pivot Table

Hi, I have a Pivot Table below and I would like to add a new row to the existing table and the value to be displayed will be 100 for FY24 (Apr-2023 to Mar-2024) and 200 for FY25 (From Apr-2024 Onwards).

MCFH93_0-1718764732402.png

Below are the load script.

-------------------------------------------------------------------------------

Table_1:
LOAD Period AS SM4_DATE_1,
[Water consumption (CbM)] AS SM4_VALUE_1,
'Office' AS SM4_SOURCE_1
FROM
TABLE_1
(OOXML, EMBEDDED LABELS, TABLE IS Offices);

Table_2:
LOAD DATE(FLOOR(Period), 'MM/YYYY') AS SM4_DATE_2,
[Water consumption (CbM)] AS SM4_VALUE_2,
'Central Office' AS SM4_SOURCE_2
FROM
TABLE_2
(OOXML, EMBEDDED LABELS, TABLE IS Summary);

Labels (1)
  • Other

1 Reply
marcus_sommer

Just create another Excel with the needed data - maybe per copy & paste from the others and then adjusting the values. Alternatively you may add these data within an inline-load but it won't be simpler.

Beside this both tables have the same data and therefore they should be loaded per concatenate into a single table with the identically field-names.