Re: How to add new rows in existing table in Qlik ... - Qlik Community

DiegoR · ‎2018-09-04

Hi everyone.

I have a table with two fields an "n" rows. I get new data daily from a Web and I need add these values into the existing table. Any suggestions?

Thanks in advance.

dwforest · ‎2018-09-04

Are you asking if Qlik has input controls? No, it is a dashboarding tool.

To append rows to an existing dataset, use the INCREMNTAL load methodology.

DavidŠtorek · ‎2018-09-05

Hi,

how do you get data from web? Is it xml,json,scv or something like that? Is it stored somewhere in folder? Where is your initial table from?

I need to know those answers to help you.

rittermd · ‎2018-09-05

You would need to run a load script daily/hourly that would pull in the new data and add it to your existing data.

How you do this would depend on many factors and we would need more information on the specifics of your project.

DiegoR · ‎2018-09-05

Thank you Mark.

I have an Excel table with historic currencies (COP and CFA) and its dates until 31/08/2018. Every day, I need to get data from Cours de référence des principales devises contre Franc CFA | BCEAO and Superintendencia Financiera de Colombia about official currency of the day and append it to a table with the historic currencies.

How to add new rows in existing table in Qlik Sense?