Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Okay so this is a simple question, but for the life of me i cant figure it out. My code below as inefficient... How can i move the section of code where I create VaccYear, into the previous table statement, such that I don't have to load a table twice....
[ForecastTableTemp]:
Crosstable(VaccName,FcQty)
LOAD *
Resident Table;
Drop table Table;
[ForecastTable]:
LOAD *,
VaccName & [Forecast Year] as VaccYear <------- how do i move this to the previous table creation statement??
Resident ForecastTableTemp;
Drop table ForecastTableTemp;
Since VaccName is being created in crosstable statement, it can't be referred in the same load or even using preceding load statement. I.e. an additional load statement would be required.
Hi,
you can use subroutine script control statement to jump from one section to another( PFB link for your reference).
please correct me if i haven't understood your requirement.
if you found this helpful, please mark helpful or correct.
Regards,
Bhasker Kumar