Concatenate Cross Tables Error

[akuttler]

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

[Digvijay_Singh]

What if you remove Concatenate key word, I haven't tested but I hope it would automatically concatenate by virtue of having exact name and no of fields in two loads.

[ChennaiahNallani]

Remove Concatenate statement it'll work fine.

[jonathandienst]

Unfortunately, you can't crosstable and concatenate in a single operation.

You will have to concatenate before performing the crosstable, or put the second crosstable into a temp table and then concatenate the temp table to the result of the first crosstable.