Interoperability recipes

These recipes are part of the HXL cookbook. Each recipe describes a general problem related to data interoperability, then shows how to use the HXL standard and the command-line tools to solve the problem.

Recipes

TODO

I.1. Reorder columns

Problem: one of your data partners has an older system that requires sector always to be the first column in your data.

Recipe: use hxlcut (command) to change the order of the columns in your dataset.

A side-effect of the hxlcut command is the ability to specify a new order for the columns with the argument to the --include_ option. For example, assuming that your dataset usually has columns in the order #org, #sector, #adm1 #adm2, the following command will reorder them so that the sector appears first:

hxlcut --include sector,org,adm1,adm2 input-data.csv output-data.csv

I.2.