Concatenate - not possible with Cross-LOADs?

[datanibbler]

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

[sunny_talwar · Accepted solution]

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]

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?