Concatenate not working

[Gabriel]

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

[alexandros17]

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]

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]

Thanks,

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

[jvishnuram]

Hi

You need to drop the main table.

[alexandros17]

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]

Hi,

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

[alexandros17]

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

[Gabriel · Accepted solution]

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