Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

effendi_baba
New Contributor

Excel data

Hi everyone

I am new to Qlik Sense. I am developing a dashboard on a local copy of Qlik Sense. I've uploaded data from an excel sheet, to start working on my layout, visualization etc. I intend to send the qvf file to another user. They will need to upload more data.

Using a load editor, I realized data will be uploaded to the same set, meaning subsequent loads will be appended to the original load. I uploaded the first bath using the data loader and the second batch using load script. And I have not succeeded. Any can help me with the right approach?

1 Solution

Accepted Solutions
adwitiya
Contributor

Re: Excel data

Hi Effendi,

Use Load editor to load all tables. Use a 'concatenate' function between them. Your column names should be consistent to achieve the correct end table.

Let me know if that was helpful.

4 Replies
effendi_baba
New Contributor

Re: Excel data

It seems my solution to write a  load script using concat function.

adwitiya
Contributor

Re: Excel data

Hi Effendi,

Use Load editor to load all tables. Use a 'concatenate' function between them. Your column names should be consistent to achieve the correct end table.

Let me know if that was helpful.

effendi_baba
New Contributor

Re: Excel data

Thank you

effendi_baba
New Contributor

Re: Excel data

Thanks a lot.

Community Browser