Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jonesbrown
Contributor

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.

1 Reply
Partner
Partner

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

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>;