data transformation input

KNIME Analytics Platform
1

Hi I need some suggestions on data transformation: I get an instrument file looking like this

image
image720×282 4.16 KB

I have plety more columns to thr right the more measurements are made.

I would like to have it converted to:

image
image560×545 8.4 KB

basically shorten things to 3 columns, ID - x and y

any suggestions?

2

Welcome to the forum @Soborg2014.

What file format is the instrument file originally?
Can you share the data (real or an example)?

3

Hi, it is exported as a text file: I just pasted osmehtig into excel :slight_smile:
data_transform.xlsx (13.8 KB)
any suggestions on how to transform it into 3 columns?

4

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.

1 Like
5

here u are :slight_smile:

example.txt (5.6 KB)

6

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?

7

yes - the x_µm are always the same, also the amount of rows are always the same :slight_smile:

8

Here’s a workflow that should get you started:

image
image1388×1017 105 KB