Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi!

Use one of the scripting processors. For example, in Jython you'd write the following code:

for record in records:
  try:    
    #Loop through column names array & create root level fields for each column with respective values from column values list 
    for index,col in enumerate(record.value['columnnames']):
      record.value[col] = record.value['columnvalues'][index]

    #Optionally delete original lists
    del record.value['columnnames']
    del record.value['columntypes']
    del record.value['columnvalues']

    # Write record to processor output
    output.write(record)
  except Exception as e:
    # Send record to error
    error.write(record, str(e))

This code will result in the following:

image description

Hope this helps.

Cheers, Dash