2 Replies Latest reply: Sep 29, 2017 11:28 AM by Philippe BONNIN RSS

    INTEGRATE NEW TABLE IN LOADING SCRIPT

    Philippe BONNIN

      Hi everybody

       

      i made a app. working pretty good (i join an extract to see the loading script) with 4 principal data files (2 with real datas, and 2 with goal datas) and 1 with nomenclature List

       

      For my set analysis I have a master calendar (MM, YYYY), several flags (current Year, Previous Year, Goal Year /special thank's to Sunny for that), and possibility to switch between calendar Year or Fiscal Year.

       

      My issue is :

       

      The users can do several predictive simulations (Goal) per year (with predictive label as well).

       

      so i import a table for that with number (highlighted), year, and label for each simulation

       

      TAB_SIM.png

       

       

      I need help to integrate correctly this table in my loading script ...



       

      I think i have to,create a key number_year (SIP_CDSIMP&SIP_EXE) , but i don't know the script to make to be compatible with my calendar MonthYear 

       

      if anyone can take a look to my script  i would be very helpful ...

       

       

       

       

      PS : tables with real datas are PDFPR & PDVMS

                tables with GOAL datas  are PDFPP & PDVMP : below the script concerning these 2 tables (with simulation's number hightlighted)

      LOADING GOAL.png

       

       

      Regards

        • Re: INTEGRATE NEW TABLE IN LOADING SCRIPT
          Philippe BONNIN

          I try again with more details to arouse your interest ;-)

           

          here are my 2 tables (forecast) already loaded

           

          FPP.png    VMP.png

           

          Here is the table that i want to load

           

          TAB_SIM.png

           

          What i expect in my set analysis is  to select year or Month_Year, then to be able to select the right number of forecast simulation (or best the forecast label !) for visualizations that require it.

           

          I tried several scripts to link the new table based on year to my actual script based on MonthYear … I failed .

          Please, some help would be appreciate !

          Regards

          Philippe