topic Noconcatenate in QlikView

Noconcatenate

Mon, 01 Mar 2010 13:43:47 GMT

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

Noconcatenate

Mon, 01 Mar 2010 13:47:29 GMT

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

Noconcatenate

wizardo — Mon, 01 Mar 2010 13:55:55 GMT

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

Noconcatenate

Mon, 01 Mar 2010 13:58:29 GMT

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

Noconcatenate

wizardo — Mon, 01 Mar 2010 14:03:52 GMT

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;

Noconcatenate

Mon, 01 Mar 2010 14:52:45 GMT

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.

Noconcatenate

Mon, 01 Mar 2010 15:43:49 GMT

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

Noconcatenate

Mon, 01 Mar 2010 16:07:17 GMT

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

Noconcatenate

wizardo — Mon, 01 Mar 2010 16:31:31 GMT

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