Write, Bureaucrats, Administrators
3,246
edits
Difference between revisions of "How to separate Xero Tracking Categories into distinct columns using Power Query"
Jump to navigation
Jump to search
How to separate Xero Tracking Categories into distinct columns using Power Query (view source)
Revision as of 23:46, 10 February 2022
, 23:46, 10 February 2022no edit summary
(Created page with "To separate Xero Tracking Categories into distinct columns, follow these steps. # Within the '''Power Query''' editor, under the '''Add Column''' tab in the ribbon, click on...") |
|||
| Line 11: | Line 11: | ||
: '''[Table]''' is the name of the field storing the Xero Tracking Categories. | : '''[Table]''' is the name of the field storing the Xero Tracking Categories. | ||
: '''[FieldTrackingCategory]''' is the name of the field within the Xero Tracking Categories table that provides the name of your tracking category. | : '''[FieldTrackingCategory]''' is the name of the field within the Xero Tracking Categories table that provides the name of your tracking category. | ||
: '''"TrackingCategoryName" is your Xero Tracking Category name. | : '''"TrackingCategoryName"''' is your Xero Tracking Category name. | ||
: '''[FieldOption]''' is the name of the field proving the Xero Tracking Category Option. | : '''[FieldOption]''' is the name of the field proving the Xero Tracking Category Option. | ||
Example: | Example: | ||
: Tables.SelectRows([LineItems.Tracking], each [Name] = "Region"){0}[Option] | : Tables.SelectRows([LineItems.Tracking], each [Name] = "Region"){0}[Option] | ||
== Related Topics == | |||
[[Troubleshooting Guides]] | |||
[[Category:Troubleshooting]] | |||