Transforming the Tasks query

To transform the Tasks query, perform the following steps:

  1. Click on the Tasks query in the Queries pane. Notice that there are only three Applied Steps in this query: Source, Navigation, and Changed Type. The two columns are named Column1 and Column2. Also, note that the first row contains the values TaskID and Category0. We want the values in this first row to be the names of our columns.
  2. Click the Navigation step in the Applied Steps area of the Query Settings pane.
  3. Click the Transform tab and choose Use First Row as Headers, the second icon from the left. An Insert Step message will be displayed, asking you to confirm the insertion of a step into the query:

Figure 12: Insert Step dialog
  1. Click the Insert button. Notice that a Promoted Headers step has been inserted between the Navigation step and the Changed Type step. Our column headers are now TaskID and Category.
  2. Click on the Changed Type step and notice that an error is displayed. This is because the Changed Type step was referring to the columns as Column1 and Column2, but now these columns are called something different.
  3. Remove the Changed Type step by clicking on the X icon to the left of the step name.
  4. Now, change the data types of both columns to text.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.145.173