Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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.

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Thank you

Anonymous
Not applicable
Author

Thanks a lot.