Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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>;