SAP Connector and For Next - Qlik Community

ralph_graham · ‎2015-04-19

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

Anonymous · ‎2015-04-19

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);