7 Replies Latest reply: Aug 1, 2017 10:34 AM by Alison Cooke RSS

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

    Alison Cooke

      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?