Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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];
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];
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];
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?
Screenshot of the error message?
No problem:
Hahahaha did you forget to remove Left Join on top of CrossTable? or was this to test me
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.