Created: 2017-11-20 01:17:07      Last updated: 2017-11-20 06:07:21

Arrrgh! The exported data file format for the Malvern Zetasizer is insane!

Row1, x1,x2,x3,x4,....,y1,y2,y3,y4,....
Row2, x1,x2,x3,x4,....,y1,y2,y3,y4,....
Row3, x1,x2,x3,x4,....,y1,y2,y3,y4,....

This workflow imports the txt file, takes each row and reformats as table with 3 columns: Size, Intensity, Volume. Then exports the data for each row to a new tab in Excel. Or you can just use KNIME to plot and prepare reports (to do).

The TableRow2Variable node allows you to name the tabs in Excel from a Column in KNIME. If you use the SampleName column, be aware that Excel truncates the tab name to the first 31 characters, so your tabs WILL be overwritten if you use long sample names.

TO DO: Graph and send to BIRT reports; Send SampleName and summary data to BIRT reports.

Information Preview


Information Run

Not available

Information Workflow Components

Not available

Information Workflow Type


Information Uploader

Information License

All versions of this Workflow are licensed under:

Information Version 2 (latest) (of 2)

View version:

Information Credits (1)


Information Attributions (0)



Information Tags (4)

Log in to add Tags

Information Shared with Groups (0)


Information Featured In Packs (0)


Log in to add to one of your Packs

Information Attributed By (0)



Information Favourited By (0)

No one

Information Statistics


Citations (0)


Version History

In chronological order:

Reviews Reviews (0)

No reviews yet

Be the first to review!

Comments Comments (0)

No comments yet

Log in to make a comment

Workflow Other workflows that use similar services (0)

There are no workflows in myExperiment that use similar services to this Workflow.