Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Remove Concatenate statement it'll work fine.
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.