Page 294 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

• Move Up and Move Down – Rearrange the order your queries appear in the list or within the folder groups to
add to your organisational efforts. This can also be done by dragging and dropping the query to a new location.

• Create Function – Turn your query into a query function. They allow you to pass a parameter to the query and
return results based on the parameter passed.
• Convert To Parameter – Allows you to convert parameters to queries or queries to parameters.
• Advanced Editor – Open the advanced editor to edit the M code for the query.

• Properties – Allows you to change the query name, add a description text and enable Fast Data Load option
for the query.

If you right click any empty area in the query list, you can create a new query.
The Data Preview

The main job of the data preview area is to apply transformation steps to your data and show a preview of these
steps you’re applying

In the data preview area, you can select columns with a few different methods. A column will be highlighted in a
light green colour when it’s selected.
• Select a single column with a left click on the column heading.
• Select multiple adjacent columns with a left click on the first column heading, then hold Shift and left click on
the last column heading.
• Select multiple non-adjacent columns by holding Ctrl then left click on any column headings you want to select.

281

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77