Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
Are those hardcoded markers named differently? Can you name them the same?