3 Replies Latest reply: Feb 15, 2018 12:05 AM by Jonathan Dienst RSS

    Concatenate Cross Tables Error

    Ashley Kuttler

      Hello,

       

      I have the following script:

       

      AGING_DETAIL_CROSSTABLE:

      CrossTable ([Buckets],[Balance],1)

      LOAD

          "Date of AR Run",

          "IB 30",

          "IB 31 to 60",

          "IB 61 to 90",

          "IB 91 to 120",

          "IB Over 121"

          FROM [lib://BACKUP/INSAGINGDETAIL_2017.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);



      Concatenate

      CrossTable ([Buckets],[Balance],1)

      LOAD

          "Date of AR Run",

          "IB 30",

          "IB 31 to 60",

          "IB 61 to 90",

          "IB 91 to 120",

          "IB Over 121"

          FROM [lib://BACKUP/INSAGINGDETAIL_2018.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);



      Its giving me an error "illegal Combination of prefixes. How would I append these two files into one table?


      Thanks