Transpose a column data into single row as flow variable

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 :
image

Screenshot 2:
image

Really appreciate your help.

@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)

3 Likes

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

2 Likes