Help for this page

Select Code to Download


  1. or download this
    Account    Entity    Unit    Jan    Feb    Mar
    Account01    Entity01    Unit01    1    2    3
    Account01    Entity01    Unit01    4    5    6
    Account01    Entity01    Unit01    7    8    9
    Account02    Entity02    Unit02    10    11    12
    
  2. or download this
    Account    Entity    Unit    Jan    Feb    Mar
    Account01    Entity01    Unit01    12    15    18
    Account02    Entity02    Unit02    10    11    12
    
  3. or download this
    CREATE TABLE concat_FRA3 AS
      SELECT Account, Entity, Unit, 
        SUM(Jan) Jan,
    ...
        SUM(Mar) Mar
      FROM concat_FRA2
      GROUP BY Account, Entity, Unit;
    
  4. or download this
    # Store
    my %storage;
    foreach my $row (@$result_set) {
    ...
        }
        $storage{$hash_key} = $new_row;
    }