Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;