- How to Import Data
- File Formats
- How to Import with Copy & Paste
- How to Set Column Headers
- Paste Special
- Paste Special Example: The decimal separator
- How to Append Data into Existing Columns
Join the Community
Groups can be used to organize commands, apply a mask to multiple commands at once, or to ‘clip’ one or more commands.
Use groups to organize like commands.
Groups can be closed to reduce the length of the command list.
Command groups can apply a mask (data filter) to multiple commands at once.
By default the Mask is set to ‘Include all’.
For example, if you have a Points command and a Fit command where you want to remove a point from both.
Instead of placing a mask in each drawing command, place the mask at the group level.
Select the conditions for the mask on the group:
Click the plus symbol next to the mask to add more criteria.
When you add multiple criteria, a new menu shows on the right that specifies how the criteria are applied. By default, this menu is set to apply all criteria, as indicated by the ‘&’ statement.
In this example, a country cannot be New Zealand and Iceland, so nothing is plotted.
To apply either criteria, change the menu to ‘|’.
Nest groups to apply multiple criteria. Here we apply a date criteria and the country criteria to the Pivot command.