Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suresh_cholleti
New Contributor

How to append data to already existing table in Qlik Sense Desktop

Hi

I'm struggling with following requirement. Can anyone help on this

1. There are 96 csv files with same columns data for one day.

2. Initially i have loaded 90 csv files data to X table using script in data load editor

3. Now i want to append data of 91st csv file to 96th csv fie to already existing table 'X' which already posses data of 1st csv file to 90th csv file.

Can anyone help on this.

Thanks for support.

Suresh Cholleti

1 Solution

Accepted Solutions
Employee
Employee

Re: How to append data to already existing table in Qlik Sense Desktop

If the field names are the same, continue to load the additional files and they should auto concatenate to X

7 Replies
Employee
Employee

Re: How to append data to already existing table in Qlik Sense Desktop

If the field names are the same, continue to load the additional files and they should auto concatenate to X

suresh_cholleti
New Contributor

Re: How to append data to already existing table in Qlik Sense Desktop

Hi

Thanks for the revert.

But here we have one more issue,

Fields names are same, but file names from which Field names should be extracted are different.

Sample Filenames :

vLteERabStatsCsv_26062018_0215_0230

vLteERabStatsCsv_26062018_0200_0215

Currently I'm using,

ERAB:

LOAD *


FROM [lib://Data/NMS16/vLteERabStatsCsv*.csv]

(txt, codepage is 28592, embedded labels, delimiter is ',', msq)

Where MATCH([BSName],'CloudsAV1K','Clouds Corridore AV500');

& we can do like this also

ERAB:

LOAD *


FROM [lib://Data/NMS16/vLteERabStatsCsv_25062018*.csv]

(txt, codepage is 28592, embedded labels, delimiter is ',', msq)

Where MATCH([BSName],'CloudsAV1K','Clouds Corridore AV500');

But here, I need change File name manually multiple times.. whenever i load script.

Is there any other way to go ahead with this??

Employee
Employee

Re: How to append data to already existing table in Qlik Sense Desktop

What is the logic to define the field name ?  Wildcards will work, but if this is regularly changing and you don't want to reload old files, you can store older values in QVD files and use incremental loads for newer data.

suresh_cholleti
New Contributor

Re: How to append data to already existing table in Qlik Sense Desktop

"If the field names are the same, continue to load the additional files and they should auto concatenate to X"


Its not happening like that, when i change Load file from this vLteERabStatsCsv_25062018*, its adding only 25th data to X table & deleting 1 to 24 th data..

Can u check & let me know.. How to overcome this?

Employee
Employee

Re: How to append data to already existing table in Qlik Sense Desktop

Every time you do a reload, it will load all the data, so if you change the name you replace the previous data.

If the names are very different do multiple load statements and they will autoconcatenate together.

suresh_cholleti
New Contributor

Re: How to append data to already existing table in Qlik Sense Desktop

I'm not changing the table name or Fields which i selected. Just changing

File Name

FROM [lib://Data/NMS16/vLteERabStatsCsv_26062018*.csv].. and all Fields Table data remain constant all the time.

I want to append 26th Fields data to already existing (1 to 25th) data - table.

suresh_cholleti
New Contributor

Re: How to append data to already existing table in Qlik Sense Desktop

Names are same, but if i use multiple load statements then its taking more run time approx 26 minutes to run for entire june month data.. & each day consists of 96 csv files.. where Field names always remain constant for all files.

Juz there change in Date and time thats it..

So i want to reduce run time. How can i go through it?

Community Browser