zetasizer2excel

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

Medium

Information Run

Not available


Information Workflow Components

Not available

Information Workflow Type

KNIME

Information Uploader

Information License

All versions of this Workflow are licensed under:

Information Version 2 (latest) (of 2)

View version:

Information Credits (1)

(People/Groups)

Information Attributions (0)

(Workflows/Files)

None

Information Tags (4)

Log in to add Tags

Information Shared with Groups (0)

None

Information Featured In Packs (0)

None

Log in to add to one of your Packs

Information Attributed By (0)

(Workflows/Files)

None

Information Favourited By (0)

No one

 

Citations (0)

None


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.