Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jonesbrown
Creator
Creator

I have one Excel Souce Data These are my sheets   1.Products, 2.Customers,3.Country,4.Branch,5.Sale

Hi All

I am new to Qlikview 

I have one Excel Souce Data These are my sheets  

1.Products, 2.Customers,3.Country,4.Branch,5.Sales 

and my Another Source Data in . CSV File  2018 Sales

my Requirement is Concatenate 2018 Sales Data.csv file data to Sales Table.

plz help.

Labels (1)
1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Hold ctrl+E to enter "Edit Script".

At the bottom panel, by default you be in the first tab <Data>, click Table Files and select your first table.

You will have this example script generated after selecting your table:

Table1:

load

<Column Name1>,

<Column Name2>,

<Column Name3>

from <ExcelPath>

Add the script function <Concatenate> in between the two Sales table. Eg:

 

Table1:

load

<Column Name1>,

<Column Name2>,

<Column Name3>

from <ExcelPath>;

Concatenate

Table2:

load

<Column Name1>,

<Column Name2>,

<Column Name3>

from <CSVPath>;