How to Add a Row in an Existing Table

[khanashique]

Hi Experts,

Below is the table which shows data after mapping 2 different data table. I need to add a row in the table below by including 3rd data table.

   Existing Table, Description is Dimension and rest Measures.

Description	Year 2016	Year 2017	Year 2018
Sales	1,427,069	952,298	926,012
Materials Cost	1,121,564	695,966	584,383
Operating Expenses	102,200	64,668	63,634
Other Expenses	42,786	14,484	13,339
Financial Charges	71,776	62,797	53,674
Depreciation	172,699	168,968	145,631

Red Highlighted Row Need to be added:  

Description	Year 2016	Year 2017	Year 2018
Sales	1,427,069	952,298	926,012
Materials Cost	1,121,564	695,966	584,383
Operating Expenses	102,200	64,668	63,634
Other Expenses	42,786	14,484	13,339
Financial Charges	71,776	62,797	53,674
Depreciation	172,699	168,968	145,631
Volume	1427	952	926

Thanks,

MAK.

[PabloTrevisan]

Hi Ashik,

you can add a new table in the model and concatenate

script:

IncludeData:

Load * INLINE [

Description, [Year 2016], [Year 2017], [Year 2018]

Volume, 1427, 952, 926

];

concatenate

LOAD *

from your table;