Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Can the Join prefix be used in combination with the Crosstable prefix?

Hello All,

I am wondering, can the join prefix be used in combination with the Crosstable prefix?

For example,

LEFT JOIN

[Q2 Project Budget]:

CROSSTABLE ([Date],[Project Budget Amount],1)

LOAD [Project Budget] as [Item],

[42826],

[42856],

[42887]

FROM [...

When I load this I get the following error: 'Illegal combination of prefixes'


Any advice?

Tags (3)
1 Solution

Accepted Solutions

Re: Can the Join prefix be used in combination with the Crosstable prefix?

This is not possible, however you can do this

[Q2 Project Budget]:

CROSSTABLE ([Date],[Project Budget Amount],1)

LOAD [Project Budget] as [Item],

[42826],

[42856],

[42887]

FROM [...

LEFT JOIN (TableName)

LOAD *

Resident [Q2 Project Budget];


DROP Table [Q2 Project Budget];

7 Replies

Re: Can the Join prefix be used in combination with the Crosstable prefix?

This is not possible, however you can do this

[Q2 Project Budget]:

CROSSTABLE ([Date],[Project Budget Amount],1)

LOAD [Project Budget] as [Item],

[42826],

[42856],

[42887]

FROM [...

LEFT JOIN (TableName)

LOAD *

Resident [Q2 Project Budget];


DROP Table [Q2 Project Budget];

Re: Can the Join prefix be used in combination with the Crosstable prefix?

While you are doing this, might as well fix the dates also

[Q2 Project Budget]:

CROSSTABLE ([Date],[Project Budget Amount],1)

LOAD [Project Budget] as [Item],

[42826],

[42856],

[42887]

FROM [...

LEFT JOIN (TableName)

LOAD Item,

    Date(Num#(Date)) as Date,

    [Project Budget Amount]

Resident [Q2 Project Budget];


DROP Table [Q2 Project Budget];

Not applicable

Re: Can the Join prefix be used in combination with the Crosstable prefix?

Hi Sunny,

Thank you.

I am trying to join Q2 Project Budget to a table called Q1 Project Budget. As such the script reads:

LEFT JOIN ([Q1 Project Budget])

LOAD *

Resident [Q2 Project Budget];

DROP Table [Q2 Project Budget];

When I load that I get this error: Illegal combination of prefixes

Why is this?

Re: Can the Join prefix be used in combination with the Crosstable prefix?

Screenshot of the error message?

Not applicable

Re: Can the Join prefix be used in combination with the Crosstable prefix?

No problem:

Screenshot (68).png

Re: Can the Join prefix be used in combination with the Crosstable prefix?

Hahahaha did you forget to remove Left Join on top of CrossTable? or was this to test me

Capture.PNG

Not applicable

Re: Can the Join prefix be used in combination with the Crosstable prefix?

Sorry yeah I was being foolish. When I start asking other to help I don't stop to look at it carefully myself.
Thank you for your help.

Community Browser