Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks a lot guys for your help. I have now resolved it.
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
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.
Thanks,
However when I take the resident and reload, I have Sync key.
Hi
You need to drop the main table.
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
Hi,
In my example above, table 2 is not appearing in the final table?
I trucated your script because the following (from calc_table on) was correct, you had only to cange tables names
Thanks a lot guys for your help. I have now resolved it.