Transpose a column data into single row as flow variable

[Dheeraj_7716]

Hi Team,

I am using Knime 4.2. I have 2 Databases. Output of DB1 Query Reader (Screenshot 1) is input for DB2 Query Reader (Screenshot 2). I wish to use it in where clause of DB2 Query Read to select only the required ID’s from DB1.

Screenshot 1 :

Screenshot 2:

Really appreciate your help.

[mlauber71]

@Dheeraj_7716 the way to go would be GroupBy and (Unique) Concatenate or a List that you could then split.

kn_forum_46765_group_list.knwf (14.8 KB)

[Dheeraj_7716]

@mlauber71 This solution works flawless! Thank you so much! Really appreciate it.