Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Gabriel
Partner - Specialist III
Partner - Specialist III

Concatenate not working

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

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III
Author

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

View solution in original post

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

jvishnuram
Partner - Creator III
Partner - Creator III

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.

Gabriel
Partner - Specialist III
Partner - Specialist III
Author

Thanks,

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

jvishnuram
Partner - Creator III
Partner - Creator III

Hi

You need to drop the main table.

alexandros17
Partner - Champion III
Partner - Champion III

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

Gabriel
Partner - Specialist III
Partner - Specialist III
Author

Hi,

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

alexandros17
Partner - Champion III
Partner - Champion III

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


Gabriel
Partner - Specialist III
Partner - Specialist III
Author

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