Join DataTable by Passing Key Columns through Config File

[supermanPunch (Arpan)]

@dimple.khurana

if I pass 1 key column in the config file, it should join the tables on that 1 key column, if I pass 2 key columns, it should join on 2 key columns and so on.

Hi @dimple.khurana ,

Maybe we could try Combining the values of the columns that are needed to considered for joining into a Single column value and then perform the Join on those Merged Column of both Datatables.

Could check the below post on the implementation and then perform Left Join using Join Datatables activity :

Dynamic Join columns

@Vineet_Joshi Option: JoinCol Datacolumn Expression hava a sample data like [grafik] and an array with the current JoinColumns, which can dynamic created [grafik] then we can dynamicly generate the helper column Expression string: [grafik] [grafik] and set it as Expression to the helper column [grafik] As you see in the flow: [grafik] with the help of expression the helper col is filled / populated wthout any loop in one go before: [grafik] after setting the expression [grafik] …