4 Replies Latest reply: Mar 23, 2017 7:19 AM by Karthik Chinnas RSS

    %pickmetric doesn't show up in list box

    Karthik Chinnas

      Good morning all!

       

      I have the below load script and it loads all well and I can make charts etc. However, when I try to create a listbox with the inline table (%pickmetric, %metric), I cannot see this option in listbox. I can see in the data model all three tables and there is data island created for the third table and the first two tables connected to each other. Any help is appreciated.

       

      set hideprefix = '%';

      TempStaffing:
      LOAD Site,
      Division,
      Directorate,
      StaffGroup,
      CC as CostCentre,
      [CC Description] as CostCentreUnit,
      AC as JobNo,
      [AC Description] as JobTitle,
      pick(match(Period, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12), 'Apr-16', 'May-16', 'Jun-16', 'Jul-16', 'Aug-16', 'Sep-16', 'Oct-16', 'Nov-16', 'Dec-16', 'Jan-17', 'Feb-17', 'Mar-17') as Month,
      [Budget wte],
      [Actual wte],
      Budget,
      Actuals,
      Category
      FROM
      …..qvd]

      Temporarytable:
      LOAD * INLINE [
      %pickmetric, %metric
      TotalSpend, Actuals
      TotalBudget, Budget
      ]
      ;

      CategoryGrp:
      LOAD Category,
      CategoryGroup
      FROM
      [Staffing Mapping Table.xlsx]
      (
      ooxml, embedded labels, table is Sheet1);