As per the above image I have this data set where one project has two different action types with their descriptions. If the action types are match with each other can take one action type and its description since both are equal but if the action types are different then I have take both action types into one column. Whereas, if one of the action types is blank then I have to take the other one to the new column. If both are blank no action needed.
The output looks like this,…
Also I have uploaded the sample data set if anyone can sort this out for me.
Thanks in advance.
knime help.xlsx (11.9 KB)