Help Normalise data from "wide" to "narrow" using the headers as labels. This filter uses the special +label attribute to identify columns.
+label
Help Rename and retag an existing column.
Help Include rows that match any of the following queries
Help Add a new column (with a constant value) to the data.
Help Combine multiple HXL datasets.
… or pick a dataset from HDX or Dropbox or Google Drive
Help Combine multiple HXL datasets using an external list.
Help Clean up your dataset by standardising dates and numbers, removing whitespace, etc.
Help Aggregate HXL data to generate reports or protect private data.
Count unique combinations of values from columns matching one or more of these tag patterns (comma-separated). If blank, count unique combinations of values from all columns.
Count values from rows matching this row query. If blank, count values from all rows.
Help Remove columns from your dataset.
Help Remove duplicate rows from a dataset.
Help Expand lists by duplicating rows
If blank, expand lists in all columns containing the +list attribute
Defaults to "|" if unspecified.
If checked, correlate the list items in multiple columns; otherwise, generate their Cartesian product (one row for each possible combination). Has no effect if you select only a single column.
Help Fill empty cells from previous values in the same column.
Help Denormalise data from "narrow" to "wide".
Help Extract a value from a JSON expression in a cell using a JSONPath expression.
Help Add columns from another dataset, based on common keys.
Help Replace values in the dataset.
Help Replace values using an external mapping table.
Help Sort the records in a HXL dataset
<HXLIOException: Unable to read HDX resource: Not found>