getting my measurement data to right layout to analyse it

[JonahGlsr]

Hi Knime Community,

I’m currently working on an measurement evaluation tool in Knime.

After some filtering with SQL I’m getting my data from an database, that looks something like this:

I’m currently using an loop (some pivoting and group by Nodes) to generate an table that looks like this

Now I want to do some calculations with my data.
Tool A produces data pre manufacturing process and Tool C produces post process measurement data.

I’ve tried using the math forumula multicolumn and the normal math forumula node to for example calculate “Para 21 minus Para 3”

Here is the problem: Parameter 21 is empty (missing value = n/a) in the first row, so I 'cant calculate the desired formula.

Now my question:
Is there an way to get my data to look like this?:

This seems like, it’s the only way to do my calculations.

Thanks

Best regards,
Jonah

[JonahGlsr]

I’ve found a solution for the problem… I’ve configured the group by node wrongly

[thor_landstrom]

Great to hear you found a solution!

TL