1 Reply Latest reply: Jan 6, 2013 10:54 PM by 938364 RSS

    Unable to Transpose Columns to Rows in DataExport Command

    982986
      Hi,

      The Data export code for On and Off Gives me the same result

      SET LOCKBLOCK HIGH;
      SET CACHE HIGH;
      SET CALCPARALLEL 3;
      SET DATAEXPORTOPTIONS
      {
      DataExportLevel "LEVEL0";
      DataExportColFormat ON;
      DataExportOverwriteFile ON;
      DataExportDimHeader OFF;
      DataExportRelationalFile ON;
      DataExportColHeader "Scenario";
      };

      FIX ("SAP",&CurrFcst,&Currmnth:Sep,"Forecast Employees",&CurrFY,@IDescendents("All_Cost_Center"),@IDescendents("Pay Type"),@IDescendents("Work Type"),@IDescendents("Other_Accounts")

      DATAEXPORT "File" "," $DataExportPath "0";

      ENDFIX;
      ENDFIX;


      --------------------------------------------------------------------------
      Result

      WT"|"Non-Exempt"|7|5|5|5|5|4|4|4|4|4
      "SAP"|"FY13"|"Plan"|"A100C30100"|"Forecast Employees"|"Full-Time"|"Indirect WT"|"Exempt"|3|3|3|3|3|3|3|3|3|3
      "SAP"|"FY13"|"Plan"|"A100C30110"|"Forecast Employees"|"Full-Time"|"Direct WT"|"Exempt"|8|6|6|6|6|6|6|6|6|6
      "SAP"|"FY13"|"Plan"|"A100C30120"|"Forecast Employees"|"Full-Time"|"Direct WT"|"Exempt"|7|4|4|4|4|4|4|4|4|4
      "SAP"|"FY13"|"Plan"|"A100C30130"|"Forecast Employees"|"Full-Time"|"Direct WT"|"Exempt"|4|4|4|4|4|4|4|4|4|4
      "SAP"|"FY13"|"Plan"|"A100C30160"|"Forecast Employees"|"Full-Time"|"Indirect WT"|"Exempt"|5|4|4|4|4|3|3|3|3|3

      --------------------------------------------------

      The way that i want the Data to be Represented is

      SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Jan" 5.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Feb" 5.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Mar" 5.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Apr" 5.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "May" 4.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Jun" 4.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Jul" 4.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Aug" 4.0000
      "SAP" "Plan" "Forecast Employees" "FY13" "A100C20270" "Non-Exempt" "Direct WT" "Full-Time" "Sep" 4.0000

      I believe that this issue is because of the Range that is used (&Currmnth:Sep)

      Could Someone help on this Issue.

      Thanks,
      Joe
        • 1. Re: Unable to Transpose Columns to Rows in DataExport Command
          938364
          I hope below code will give you result desired format, changes I made are in bold and italics

          SET LOCKBLOCK HIGH;
          SET CACHE HIGH;
          SET CALCPARALLEL 3;
          SET DATAEXPORTOPTIONS
          {
          DataExportLevel "LEVEL0";
          DataExportColFormat OFF;
          DataExportOverwriteFile ON;
          DataExportDimHeader OFF;
          DataExportRelationalFile ON;
          +/*DataExportColHeader "Scenario"*/+;
          };

          FIX ("SAP",&CurrFcst,&Currmnth:Sep,"Forecast Employees",&CurrFY,@IDescendents("All_Cost_Center"),@IDescendents("Pay Type"),@IDescendents("Work Type"),@IDescendents("Other_Accounts")

          DATAEXPORT "File" "," $DataExportPath "0";

          ENDFIX;
          ENDFIX;