I have a list of objects (txt file1) and a sdf file containing several information. For each object in file1 I need to extract related informations from the sdf. The problem is that in the sdf file I can have more than one row associated to the same object.
An example below:
How can I do that? I tried with JOIN node but I didn’t get what I would.
Thanks in advance.
You could try using the -GroupBy- node on just “file.sdf”. Choose column1 as the Group column, and use column2 and column3 in the manual aggregation tab. Choose the aggregation method “List” for both.
You could then use the -Split Collection Column- node to change the lists into separate columns.
This would however create slightly different ordering of columns in the end result:
BBB,2,missing value,2,missing value
You could then reorder them if required
Hope that helps
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.