Hi all, I am currently building a way in KNIME to compare two XML files with each other. This already works quite well. Unfortunately, I still have a sorting problem. I have two Collection Cells and would like to sort their contents so that I can compare them with each other. Example: Collection Cell XML1 Row 1: C,D,T,Z,Q Collection Cell XMK2 Row 1: T,Z.Q,C,D The comparison with the Table Difference Finder fails because the order is different, but the content is the same. I am looking for a way to make them look like this after sorting: Collection Cell XML1 Row 1: C,D,T,Q,Z Collection Cell XML2 Row 1: C,D,T,Q,Z What is the best way to do this? I have already tried many things but have not yet found the right solution. I hope someone here can help me.

Hi Julia, As stated by @ipazin , most probably the problem comes from the way the data were aggregated using “Concatenation” instead of "List (Sorted). Please find below a workflow with a possible solution to your question: [image] 20230105 Sort Content of a Collection Cell.knwf (49.2 KB) Hope it helps. Many greetings! Ael

Sort Content of a Collection Cell

KNIME Analytics Platform

aworker January 5, 2023, 9:34am 4

Hi @jgawin & welcome to the KNIME community,

Would the following old post in the KNIME forum be of help to answer your question ?

Best
Ael

1 Like