Rows are swapped after Join Datatable operation

Help Activities
, ,
1

Hello everyone,

I have joined the following two tables as follows.

image
image1361Ă—648 61.7 KB

image

But after the join operation, the data changes place.

image
image747Ă—99 16.1 KB

How can I fix this.

Thanks!

2

Hi @MrKezay

May I know the output that you require?

Thanks

3

image
image1003Ă—73 42.9 KB

I want it like the first one.

Thanks

4

@MrKezay

Correct me if I am wrong

your dt1:

image
image1113Ă—98 43.4 KB

your dt2:

image

your required output

image
image1009Ă—75 43.4 KB

sorry just trying to understand I can see your dt1 is same as output?

5

Sorry, I couldn’t express myself.

I want the result like the first datatable.

Order of data in first table

Alperen KEZAY
Zeynep KEZAY
Ahmet KEZAY

But output like this

Alperen KEZAY
Ahmet KEZAY
Zeynep KEZAY.

I don’t want the order of the data to change.

image (1)
image (1)747Ă—99 16.3 KB

6

Hi,

Can you try to order the result using the following expression?

out_JoinDt.AsEnumerable.OrderBy(Function(r) Array.IndexOf( dataListesiDt.AsEnumerable.Select(Function(x) x("EmployeeName").ToString).ToArray(), r("EmployeeName").ToString)).CopyToDataTable()

Regards,

7

@MrKezay
the Join DataTable can have a result where the row orders are changed e.g. compared to dt1.
Lets assume we can rely to the email for identifying a particular row, then we can reorder the the join result by following:

Assign activity
left side: dtJoinOrdered | DataTable
Righ side:

(From d in out_JoinDT.AsEnumerable
let e = d(“EmployeeAdress”).toString
let i = dataListesiDT.AsEnumerable.toList.FindIndex(Function (x) x(EmployeeAdress).toString.Equals(e))
Order by i
Select d).CopyToDataTable

8

Thank you so much @ppr and @Yoichi

Both expressions are correct. Sorry Yoichi, Peter’s solution is more explanatory I’m flagging his solution.

Thank you again, I have a lot to learn from you.