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

[#1]

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?

[sunny_talwar · Accepted solution]

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];

[sunny_talwar]

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];

[#4]

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?

[sunny_talwar]

Screenshot of the error message?

[#6]

No problem:

[sunny_talwar]

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

[#8]

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.