Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

josephinetedesc
Not applicable

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

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

1 Solution

Accepted Solutions
maverjannet
Not applicable

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

TempCrosstable:

CrossTable(Machine, AvailMins)

LOAD SchDate as DateFull,

Crosstable:

LOAD *

RESIDENT TempCrosstable;


LEFT JOIN



DROP  TABLE TempCrosstable;


3 Replies
swuehl
Not applicable

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

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;

maverjannet
Not applicable

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

TempCrosstable:

CrossTable(Machine, AvailMins)

LOAD SchDate as DateFull,

Crosstable:

LOAD *

RESIDENT TempCrosstable;


LEFT JOIN



DROP  TABLE TempCrosstable;


josephinetedesc
Not applicable

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

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!