LogoLogo
3.6.9
3.6.9
  • Introduction
  • Getting started
    • Installation
      • Prerequisites
        • Server requirements
      • On-premises
        • Single-node
          • Directory structure
        • Multi-node
      • Azure Market Place
      • AWS Market Place
    • Tutorials
      • Amazon AWS CUR
      • Amazon AWS CUR (Athena)
      • Azure Stack
      • Azure EA
      • Azure CSP
      • Google Cloud
      • VMware vCloud
      • VMware vCenter
    • How-to guides
      • How to configure receiving a monthly billing report
      • How to automatically trigger a monthly billing report
      • How to update your license
      • How to store contract information with an Account in a report
      • How to automatically send workflow errors as webhooks to a monitoring system
    • Concepts
      • User interface
      • Services
    • Releases
      • Upgrading to version 3
      • Known issues
      • Announcements
      • Archive
  • Reports
    • Accounts
    • Services
    • Instances
    • Summary
    • Budget
  • Services
    • Manage
    • Rates
      • Tiered Services
        • Aggregation Levels and the Account Hierarchy
    • Adjustments
    • Subscriptions
  • ACCOUNTS
    • Budget management
  • Data pipelines
    • Extract
      • Configuration
      • Extractor templates
      • Script basics
      • Parslets
      • Subroutines
        • check_dateformat
        • check_dateargument
        • format_date
        • validate_response
      • Language
        • aws_sign_string
        • basename
        • buffer
        • csv
        • clear
        • decimal_to_ipv4
        • discard
        • encode
        • encrypt
        • environment
        • escape
        • exit_loop
        • foreach
        • generate_jwt
        • get_last_day_of
        • gosub
        • gunzip
        • hash
        • http
        • if
        • ipv4_to_decimal
        • json
        • loglevel
        • loop
        • lowercase
        • match
        • pause
        • print
        • return
        • save
        • set
        • subroutine
        • terminate
        • unzip
        • uppercase
        • uri
        • var
    • Transform
      • Configuration
      • Transformer templates
      • Transform Preview
      • Language
        • aggregate
        • append
        • calculate
        • capitalise
        • convert
        • copy
        • correlate
        • create
        • default
        • delete
        • dequote
        • environment
        • event_to_usage
        • export
        • finish
        • Functions
        • if
        • import
        • include
        • lowercase
        • normalise
        • option
        • rename
        • replace
        • round
        • services
        • set
        • sort
        • split
        • terminate
        • timecolumns
        • timerender
        • timestamp
        • update_service
        • uppercase
        • var
        • where
    • Datasets
    • Lookups
    • Metadata
    • Reports
    • Workflows
  • Administration
    • User management
      • Users
      • Groups
    • Notifications
      • Budget Notifications
      • Report notifications
      • Workflow notifications
    • Settings
      • Global Variables
      • White Labeling
  • Advanced
    • Integrate
      • GUI automation
        • Examples
      • API docs
      • Single sign-on
        • Claims-based identity provisioning: users, Account access and user groups
        • Azure-AD
        • Auth0
        • OKTA
        • OneLogin
        • ADFS
        • LDAP
    • Digging deeper
      • Authentication flows
      • Transformer datadate
      • Dataset lifecycle
      • Config.json
      • Databases
  • Security
    • Security
    • Authentication
      • Token
      • LDAP
      • SAML2
    • Password reset
    • Password policy
    • Announcements
  • Troubleshooting
    • Logs
  • Terms & Conditions
  • Privacy Policy
Powered by GitBook
On this page
  • Overview
  • Syntax
  • Details
  • Examples

Was this helpful?

Export as PDF
  1. Data pipelines
  2. Transform
  3. Language

sort

Overview

The sort statement is used to re-order the rows in usage data

Syntax

sortdset.id [desc|descending]using|bycolumn_name [column_name ...]

Details

The sort statement will reorder the usage records in the specified DSET using one or more column names as the keys to sort by.

By default the sort will be done in ascending order but if the optional desc keyword is present after the DSET ID then the rows will be sorted in descending order.

Any number of columns to sort by may be specified but any given column name may only appear once in the list, the column names must not be fully qualified, and all the specified columns must exist in the data to be sorted.

Examples

Given the following data imported as the dset example.sort:

account,account2,service,quantity,rate,cogs,interval,instance,ref1,ref2
Account1,Subaccount1,ServiceX,100,1,0.5,monthly,Instance,zebra,echo
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,delta,echo
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,zebra,alpha
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,delta,echo
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,zebra
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,bravo
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,romeo
Account2,Subaccount4,ServiceX,100,1,0.5,monthly,Instance,golf,tango
Account2,Subaccount4,ServiceY,100,1,0.5,daily,Instance2,sierra,papa
Account2,Subaccount4,ServiceZ,100,1,0.5,individually,Instance3,xray,papa

... the following statement:

sort example.sort by ref1 ref2

... will reorder the usage records as follows.

account,account2,service,quantity,rate,cogs,interval,instance,ref1,ref2
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,bravo
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,romeo
Account1,Subaccount3,ServiceZ,100,1,0.5,individually,Instance3,charlie,zebra
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,delta,echo
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,delta,echo
Account2,Subaccount4,ServiceX,100,1,0.5,monthly,Instance,golf,tango
Account2,Subaccount4,ServiceY,100,1,0.5,daily,Instance2,sierra,papa
Account2,Subaccount4,ServiceZ,100,1,0.5,individually,Instance3,xray,papa
Account1,Subaccount2,ServiceY,100,1,0.5,daily,Instance2,zebra,alpha
Account1,Subaccount1,ServiceX,100,1,0.5,monthly,Instance,zebra,echo
PrevioussetNextsplit

Last updated 2 years ago

Was this helpful?