Some duzzits allow results to be downloaded to a csv file format, or in certain cases a positional text file format. Downloading is typically available for duzzits that return multiple rows of data. For example, most duzzits that return multiple contacts from CRM systems will allow results (in this case a list of contact data) to be downloaded to a file.
Let’s say we have a duzzit that returns a list of sample contact information consisting of a first name, last name, and city. The output definition of this duzzit (right-hand side of the duzzit editor) might look like this:
Contact is a “list” variable. This implies that when the duzzit is run, a list of contacts will be returned. Clicking on “Contact” shows how it has been defined:
Clicking on “first-name” shows how this output variable belongs to the “Contact” list:
If we run the duzzit (using test data to create multiple rows of data), we get:
We can download this as a csv formatted file. Downloading (and opening in Excel), we then see the data as:
If outputs have been configured for positional output, we’ll also have the option of downloading a file containing positional data. (Certain applications require data in a positional format for loading purposes). Here’s another view of the “first-name” output definition, with positional output (place first-name into positions 1 through 20, right justified):
For the purposes of this example, we’ll similarly configure last-name to go into positions 21 through 40, and city into positions 41 through 60. Now when we run the duzzit, in addition to a csv download option, there is also a positional download option:
Here’s what the downloaded positional output looks like:
