
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Noconcatenate
Dear all!
I really appreciate your held! could anyone please help me with this?
Thank you in advance!
I have created five tables in Excel, these tables look in the same way, but they contain different data.
My problem is when I load these tables in the script, QlikView will automatically concatenate these tables. I have tried to use NoConcatenate, but it does not work correctly.
When I use F1 for help in the script on NoConcatenate there is an error messages cannot launch the help. Could anyone show me where I should use NoConcatenate in the script?
The five tables looks like these.
Table1:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table 2:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table3:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table 4:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
I appreciate your help!
Best regards
Malin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Malin,
If help fails to load, simply go Help>Contents then index or search as required.
Anyway, the syntax is (from 'Help') is
Load A,B from file1.csv;
noconcatenate load A,B from file2.csv;
Regards,
Gordon

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hmm wll the keyword NOCONCATENATE should work
iv used it many times.
can you explain bit more what you mean by
I have tried to use NoConcatenate, but it does not work correctly.
where did you use the NOCONCATENATE and what did not work?
one problem i can see tho is that once your script is loaded and since qlikview will have 5 difrent tables with all fields matching
you will get 5 seperate table with ALL fields conected to ALL fields
not sure if QV can handle it (depends on tables sizes).
can you post a sample?
Mansyno

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Gordon!
I am very new (two month) in QlikView, and I have tried to write Noconcatenate Load. in the script, but it does not work. Maybe I am write it in a wrong way. Could you please show me how to use it in the tables above?
Thank you in advance!
Malin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
just put it between each TWO loads
Table1:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
NOCONCATENATE
Table 2:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
NOCONCATENATE
Table3:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
NOCONCATENATE
Table 4:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have done like this before:
Table1:
Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table 2:
Noconcatenate Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table3:
NoConcatenate Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
Table 4:
NoConcatenate Load
ID,
Q1,
Q2,
Q3,
Q4,
Q5,
Q6,
Q7,
Weight,
Year
From;
But when I do this, the Script Execution progress will not close when finish and I have to qlick on the abort button.
When I have done that QlikView do not answer any longer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is because Qlikview is trying to create synthetic keys across all the fields within all the tables. If the structures really have no common meaning (eg Q1 in Table1 is different type of data to Q2 in Table2) then you will have to rename the fields (or qualify them - see help for that), such as
Q1 as tQ1
Regards,
Gordon

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I use these tables for questionnaires studies. That's why all tables look the same, but they contain different data. Year is also different. The first table is for year 2003, second table for year 2004 and so on. But maybe the easiest way is to rename it. But it doesn't feel like it is the smooth way? 😃
Sorry for all these questions. But I should really appreciate if we maybe could find an elegant way to solve this problem.
Best regards
Malin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Malin,
what's improtent is not that they contain different values , the real question is if the values are the same TYPE
what i dont understand is why you need to put each one in a difrent table.
seeems to me they belong in the same logical table (you need to CONCATENATE the)
also if you want you can add a new field on each LOAD that points to the source, lke this
Table_A:
load
id ,
q1,
q2,
'Table_A' as Soruce
from;
CONCATENATE
Table_B:
load
id ,
q1,
q2,
'Table_B' as Soruce
from;
etc......
then you will have one big table containing all the xls tables, with reference to it's origin
Mansyno
