About Join Data Tables Activity

[hsupyaewoon]

Hello, everyone.
There is something I would like to know about Data Tables Activity.
I have two excel files.
One has Employee’s No, Employee’s Name and Mail-Address.
And the other has Employee’s No, Employee’s Name, Leader’s Name and Leader’s Mail-Address.
So, to join them, I used Employee’s Name from two tables joined on left and I got the table of full, means
(Employee’s No, Employee’s Name, Mail-Address, Employee’s No_1, Employee’s Name_1, Leader’s Name and Leader’s Mail-Address)
But when I use Employee’s No to join those two tables on left, and the result is different like
(values of the Employee’s No, Employee’s Name, Mail-Address only) even though the headers exit, the values aren’t.

I wanna know why is it different like that and how can I get every values of the two tables even if I use Employee’s No.

Thank you.

[pattyricarte (Patty Boy)]

Can you share your first and second excel and the output excel that you want to achieve.I will try to investigate it

@hsupyaewoon

cheers

Happy learning

[hsupyaewoon]

Hello, @pattyricarte.
I am sorry. But I am still getting confused.
Here is my excel files and can you please check it for me?
Thank you.

approver table.xlsx (11.1 KB) holiday taken.xlsx (11.1 KB) Trial4.xlsx (9.1 KB)

[pattyricarte (Patty Boy)]

What is the link between the approver table and the holiday ?

@hsupyaewoon

cheers

Happy learning

[Manish540 (Manish Shettigar)]

In join datatable activity keep it as Inner Join, you will get all the columns of both excels.

[hsupyaewoon]

Hello @pattyricarte
It’s Employee’s No = Approved Person Code or Employee’s No = Approver Code.

[hsupyaewoon]

Hello @Manish540
Thank you for your answer.
But it also couldn’t take out every result.

[pattyricarte (Patty Boy)]

Hi @hsupyaewoon

Itried you excel and create a xaml of it , and i dont see any connection between the two .Kindly check please !

cheers

Happy learning

[Manish540 (Manish Shettigar)]

You will get both datatable like this,when you keep join type as Full

@pattyricarte

[pattyricarte (Patty Boy)]

What column did you link between the two tables ?

@Manish540

cheers

Happy learning

[pattyricarte (Patty Boy)]

Hi @hsupyaewoon
I got 3 employees that have a link in each table see image for your reference.

cheers

Happy learning

[hsupyaewoon]

Hello @pattyricarte @Manish540
Thank you two for your answer.
I appreciate that.
Let me explain you what I am trying to do is.
So, i will take the data of employee’s No from holiday taken file and the data of Approved Person Code from approver table file.
Then I am gonna make a link between them and join these two tables to send emails to employee’s mail-address from holiday taken file and approver mail-address from approver table file.
The approved person can also be the approver person.
And there may be more than one approver persons for one approved person. ( 1 → n )

I just changed a littel in my excel files and can you check this again please.
Thank you.

approver table.xlsx (11.0 KB) holiday taken.xlsx (11.1 KB) Trial4.xlsx (9.1 KB)

[hsupyaewoon]

Hello @Manish540
Thank you for your answer.
I tried all of them but still I don’t get it.

[hsupyaewoon]

Hello @pattyricarte @Manish540
I could solve it.
My apology for the wrong example excel files.
I created it too quickly and didn’t realize some of the mistakes.
Thank you two for giving me time.
And sorry again for my bad data.

[pattyricarte (Patty Boy)]

No worries @hsupyaewoon your great

Happy to help here.

cheers

Happy learning