Discussion Board for collaboration related to Creating Analytics for QlikView.
Ralf - What about a more dynamic approach? Let's say we've only got 3 sites/stores right now, but that we want the script to check for possible values first before assuming it's just '1 through 3'?
You are both widening my knowledge by leaps and bounds...
Erich - Your answer was actually right on the money.. I just ignored the syntax error and let it roll, and it created each file just as it was expected to!
That was fantastic, thank you!
I just made it simple as possible so that's more understandable. It's always easy to complicate things..
Btw. the NoConcatenate is not needed in this case because the table gets dropped. If needed the right syntax is:
NoConcatenate load * resident Table
where site_id = $(vTable);
Gotcha - I see your point now also about it being dropped
I'm still fresh eyes when it comes to QV, but this community is so fantastic and helpful!
Thanks again fellas!