Hi I need some suggestions on data transformation: I get an instrument file looking like this
I have plety more columns to thr right the more measurements are made.
I would like to have it converted to:
basically shorten things to 3 columns, ID - x and y
Welcome to the forum @Soborg2014.
What file format is the instrument file originally?
Can you share the data (real or an example)?
Hi, it is exported as a text file: I just pasted osmehtig into excel
data_transform.xlsx (13.8 KB)
any suggestions on how to transform it into 3 columns?
Can you share the text file? I’m interested in seeing how it’s structured/formatted directly from the instrument, without any intervention from Excel. Ideally any KNIME workflow would need to operate on that text file and not an Excel pasted version.
I noticed that the values in the x columns are the same.
Are the values in the x_(µm) column always going to be the same for each column of y measurements?
yes - the x_µm are always the same, also the amount of rows are always the same
Here’s a workflow that should get you started: