I have just started using KNIME to analyse a larger dataset using the PCA Compute node. I am specifically interested in identifying the component with the highest loading in the respective eigenvectors (as supplied in the Spectral Decomposition table output).
What I have done so far is transpose this output, so I have one column for each eigenvector and the components as RowIDs. I am now looking for a way to detect e.g. the maximum loading for a given Eigenvector, but in terms of outputting the RowID (thus the component in my case) where this maximum is found.
Is there a way to "look up" RowIDs by the value or property of the data contained in the cells?
Thank you for your help,