Crosstable and Concatenation

[#1]

I am trying to crosstable a few files and concatenate them togheter.  When I add the  concatenation syntax, I get the following error.  "illegal combination of prefixes" 

Temp:

CrossTable(...)

LOAD * File1;

Concatenation (Temp:)

CrossTable(...)

LOAD * File2;

CrossTable(...)

LOAD * File3;

I then tried to crosstable and concatenate the  tables without the concatenate command..   If I used it without the concatenation syntax  it seems like all 3 tables concatenation automatically.   What is the right way to do this?  Is there an issue with this way?

Temp:

CrossTable(...)

LOAD * File1;

CrossTable(...)

LOAD * File2;

CrossTable(...)

LOAD * File3;

[eduardo_sommer]

Hi

If the fields are the same, qlikview will automatically concatenate the tables, unless you use the noconcatenate command.

Eduardo

[#3]

Hi Eduardo:

Thank you for response.  Do you know why I would get the error when I put in the concatenate command?

Trung

[fsimoes81]

There's no problem to use the automatic concatenation.

But, explicit concatenation, should have worked. I believe that happened because you used colon in front of table name.

Concatenation (Temp)

not

Concatenation (Temp:)

[eduardo_sommer]

It's

     Concatenate (Temp)

the right syntax

Eduardo

[fsimoes81]

Sure!!!! Sorry by my lack of attention!