SAP Connector and For Next

ralph_graham — Sun, 19 Apr 2015 17:46:01 GMT

Hello,

I'm coming across a slightly perplexing problem with setting up a for next loop using the SAP Connector. Essentially I want to split any tables that we extract with a financial year field in them so that they are separated, e.g. GPLCA_2014.qvd, GLPCA_2015.qvd etc.

I've created a for next approach in a similar way as I would usually do this but I get a Custom Read Failed message.

Any ideas or suggestions are most welcome.

Thanks,

Ralph

Re: SAP Connector and For Next

Anonymous — Sun, 19 Apr 2015 18:28:24 GMT

Not enough info. Can you show at least what you do in the "for...next" loop? I'd do something like this:

FOR YEAR = 2010 TO 2015

   GPLCA_$(YEAR):
   LOAD * RESIDENT GPLCA
   WHERE Year = $(YEAR);
   STORE GPLCA_$(YEAR) INTO GPLCA_$(YEAR).qvd (qvd);
   DROP TABLE GPLCA_$(YEAR);

topic Re: SAP Connector and For Next in QlikView

SAP Connector and For Next

Re: SAP Connector and For Next