Linq Query Issue

[ppr (Peter Preuss)]

@kantheshm
is the data from link below represing the sample data and expected output for this topic case?

Linq Query, Please Help!

Hi @NIVED_NAMBIAR , Thank you for helping me… Dt1 Col1 – Col2 – Col3 – Col4 A – 11 – AA – ABC B – 12 – RT – EFG C – 13 – HL – XYZ D – 27 – AA – ABC F – 15 – RT – EFG G – 24 – HL – XYZ Dt2 Col1 – Col2 – Col3 – Col4 A – 11 – AA – KLM B – 12 – RT – NOP C – 13 – HL – QRS D – 27 – AA – WXC F – 15 – RT – ASD G – 24 – HL – MKL output Col1 – Col2 – Col3 – Col4-Col5 A – 11 – AA – ABC-KLM B – 12 – RT – EFG-NOP C – 13 – HL – XYZ-QRS D – 27 – AA – ABC-WXC F – 15 – RT – EFG-ASD G – 2…

If yes, Join Columns are Col2, Col3?