Discussion board where members can get started with Qlik Sense.
I have the following script:
"Date of AR Run",
"IB 31 to 60",
"IB 61 to 90",
"IB 91 to 120",
"IB Over 121"
(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?
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.