Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

chriys1337
Contributor II

Adding data to a existent table - how to (in a clean way)

Hi all,

I am having a question regarding the style of data modelling.

There are multiple Resident Loads in my script, where I am just adding some information and therefore have to Reload the Table, rename it and drop the prior table, like shown in the script below

fact_table:

NoConcatenate Load *,

    Trade &  '_' & Matchcode as Trade_Matchcode,

    Geo_From &  '_' & Geo_To &  '_' & Matchcode as Geo_From_To_Matchcode

Resident fact_table_tmp;

Drop Table fact_table_tmp;

Is there a cleaner version of touching tables and adding information?

Happy to get some ideas from you, thx a lot.

Chris

1 Reply
thiago_pinho
New Contributor III

Re: Adding data to a existent table - how to (in a clean way)

Hey, chriys1337

           i use like you kkk