topic Re: Concatenate not working in QlikView

Concatenate not working

Gabriel — Fri, 31 Jan 2014 09:45:38 GMT

Hi all,

Can you please tell me?

what am not doing right or doing wrong.

So, I have 2 tables,

The first table starts with CrossTable which is ok. However when Load Tbl1 and Concatenate Tbl2 then have the Crosstable to transform everything into 1 table, Tbl2 doesn't appear in the final table

Example:

Tbl1:

Crosstable ([Field List]), Incomp,1)

LOAD

'Company ABC' as [Company Name],

x as x,

xx as xx,

xxx as xxx

resident tablename;

Concatenate (Tbl1)

LOAD

'Company ABC' as [Company Name],

xxxx as xxxx

xxxxx as xxxxx

Resident tablename2:

Calc_Table:

NoConcatenate

LOAD

[Field List],

Sum(Incomp) as Incomplete,

[Company Name]

Resident Tbl1;

Drop table Tbl1;

Drop table tablename2;

Hope this make sense and kindly help.

Thanks in advance

Re: Concatenate not working

alexandros17 — Fri, 31 Jan 2014 09:48:10 GMT

The problem is the keyword crosstable, you need to read that table again (deleting the first one) and then concatenate with the second:

Tbl1:

Crosstable ([Field List]), Incomp,1)

LOAD

'Company ABC' as [Company Name],

x as x,

xx as xx,

xxx as xxx

resident tablename;

TTT:

noconcatenate

load * resident Tbl1;

drop table tbl1;

Concatenate (Tbl1)

LOAD

'Company ABC' as [Company Name],

xxxx as xxxx

xxxxx as xxxxx

Resident tablename2:

.....

Hoèpe it helps

Re: Concatenate not working

jvishnuram — Fri, 31 Jan 2014 09:52:27 GMT

Hi Gabriel,

You can't do any join or concatenate operation., when you are using crosstable function.

You need to take a resident then you do what ever you want.

Re: Concatenate not working

Gabriel — Fri, 31 Jan 2014 10:21:50 GMT

Thanks,

However when I take the resident and reload, I have Sync key.

Re: Concatenate not working

jvishnuram — Fri, 31 Jan 2014 10:22:40 GMT

You need to drop the main table.

Re: Concatenate not working

alexandros17 — Fri, 31 Jan 2014 10:24:06 GMT

In my example when you reload the first table (the one with crosstable) you have to write Noconcatenate and after reloaded you have to drop it, look at my previou example

Re: Concatenate not working

Gabriel — Fri, 31 Jan 2014 10:42:41 GMT

Hi,

In my example above, table 2 is not appearing in the final table?

Re: Concatenate not working

alexandros17 — Fri, 31 Jan 2014 10:45:29 GMT

I trucated your script because the following (from calc_table on) was correct, you had only to cange tables names

Re: Concatenate not working

Gabriel — Fri, 31 Jan 2014 11:44:53 GMT

Thanks a lot guys for your help. I have now resolved it.