3 Replies Latest reply: Mar 25, 2013 10:31 AM by Adotey Kwame RSS

    Load budget data

    Adotey Kwame

      Hi

       

      I'm struggling to load and append the budget to the fact, since i cant use join or concatenate prefix before a cross table. can someone please help?

       

       

      Budget for net comm

       

      date
      Unit 1
      unit2
      1/1/131040
      1/2/132050
      1/3/133060

       

      Budget claim incurred

       

      dateunit 1
      unit2
      1/1/132045
      1/2/133045
      1/3/134058
        • Re: Load budget data
          Stefan Wühl

          You'll need to create a temporary table for your second cross table load, then do a resident load to join / concatenate to the first (take care to use NOCONCATENATE when loading the tmp table, to avoid auto concatenation to your original table).