illegal join on a crosstable - how do I makeit legal?

[josephinetedesc]

Hi all

this is the error message I get:

----------------------

Illegal combination of prefixes

left join

crosstable:

CrossTable(Machine, AvailMins)

LOAD SchDate as DateFull,

------------------------------

How do I make it legal -in the preceding table there is a field called "Machine"

Thank you

Jo Tedesco

[swuehl]

You can't directly join the CROSSTABLE loaded table, do  it in a following resident load like

...

LEFT JOIN (YourPrecedingTable)

LOAD * RESIDENT  crosstable;

DROP TABLE crosstable;

[Anonymous · Accepted solution]

TempCrosstable:

CrossTable(Machine, AvailMins)

LOAD SchDate as DateFull,

Crosstable:

LOAD *

RESIDENT TempCrosstable;

LEFT JOIN

DROP  TABLE TempCrosstable;

[josephinetedesc]

Sorry swuehlandJannet Santos  I would have marked as CORRECT but I cannot "see" where it is.   I only have the action helpful. 

a

Thank you it workded

Jo

ahhhh  - i need to do it NOT FROM the INBOX!