Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Concatenate Cross Tables Error

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

3 Replies
Digvijay_Singh
Honored Contributor III

Re: Concatenate Cross Tables Error

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
Contributor III

Re: Concatenate Cross Tables Error

Remove Concatenate statement it'll work fine.

MVP
MVP

Re: Concatenate Cross Tables Error

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser