Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
NEXT