How to create field after load statement

[Anonymous]

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;

[tresesco]

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.

[bhaskar_sm]

Hi,

you can use subroutine script control statement to jump from one section to another( PFB link for your reference).

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...

please correct me if i haven't understood your requirement.

if you found this helpful, please mark helpful or correct.

Regards,

Bhasker Kumar