Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Concatenate - not possible with Cross-LOADs?

Hi,

I have an Excel file with several tabs which I would like to read as crosstables.

However, I actually need all the tabs in one file, but each with a different Flagfield which I put in as a hardcoded text.

However, when I use the "Concatenate" statement, QlikView tells me this is an invalid combination of commands.

What am I doing wrong there or how can I get this to work?

Thanks a lot!

Best regards,

DataNibbler

1 Solution

Accepted Solutions
sunny_talwar

Yes, CrossTable Concatenate cannot be used with Concatenate CrossTable.. but if the field names between the two crosstables happens to be the same, you will get auto-concatenation... or you can use a resident load after crosstable to concatenate.

View solution in original post

3 Replies
sunny_talwar

Yes, CrossTable Concatenate cannot be used with Concatenate CrossTable.. but if the field names between the two crosstables happens to be the same, you will get auto-concatenation... or you can use a resident load after crosstable to concatenate.

datanibbler
Champion
Champion
Author

Thanks!

I thought so. Well, auto-concatenation won't do for me because I need one hardcoded ,marker for each of the tabs I load, so I will go for a RESIDENT each.

Thanks a lot!

Best regards,

DataNibbler

sunny_talwar

Are those hardcoded markers named differently? Can you name them the same?