topic Re: Crosstable and Concatenation in QlikView

Crosstable and Concatenation

Tue, 24 Jun 2014 19:20:13 GMT

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;

Re: Crosstable and Concatenation

eduardo_sommer — Tue, 24 Jun 2014 19:30:54 GMT

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

Eduardo

Re: Crosstable and Concatenation

Tue, 24 Jun 2014 19:33:45 GMT

Hi Eduardo:

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

Trung

Re: Crosstable and Concatenation

fsimoes81 — Tue, 24 Jun 2014 19:34:51 GMT

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:)

Re: Crosstable and Concatenation

eduardo_sommer — Tue, 24 Jun 2014 19:37:04 GMT

It's

Concatenate (Temp)

the right syntax

Eduardo

Re: Crosstable and Concatenation

fsimoes81 — Tue, 24 Jun 2014 20:27:35 GMT

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