How to add a row with text and formula expression in an existing loaded table in Qlik Sense

[SKum2PL]

I've a table called myTable 

Type, Year1, Year2, Year3
D1    1990   1997    2020

in this table I want to add a row

D2 1997, 2010, 2014

value of years are coming from a formula = Sum({<D_Type ='FY')>} Amount)

how to achieve this?

[henrikalmen]

You can't add rows to a table in your data model from frontend. And you can't use set analysis in load script.

In load script, you cant use the concatenate prefix in script to add rows to a table. I hope that gives you ideas on how to solve your issue.