Joining two datables of CSV and Excel

Help
, , ,
1

Hello.
I am doing the same task like the other days and today I found another problem.
Since the first time, I was using three excel files and it went well when joining the datatables.
But today I tried to join two datatables and both of them are taken out from csv files.
And also tried when one is csv and the other is excel.
But neither of them worked out.
Someone please tell me where am I doing wrong?
Thank you…

1 Like
2

@hsupyaewoon,

Are you facing any error?

1 Like
3

Can you show more details about it …why it doesnt work out ? di you encounter an error ? @hsupyaewoon

cheers :smiley:

Happy learning :smiley:

3 Likes
4

Check the both data tables have same number of columns and also matching data types.

Regards,
Karthik Byggari

1 Like
5

Hello @sarathi125 @pattyricarte
Thank you for your reply.
Nothing just came out.
Wait, I will show you details.

6

Hello @KarthikByggari
Thank you for your answer.
I don’t know how to match data type and is it necessary to have same number of columns on both files?

Here is how am I trying and please check it for me?

Trial4.xlsx (9.1 KB) new.xaml (17.6 KB) Trial7.xlsx (10.9 KB) ConfigFile2.xlsx (9.2 KB)

7

I am sorry. But I couldn’t upload csv file here.
So, let me upload these two csv files as excel files instead.

holiday taken.xlsx (11.1 KB) approver table.xlsx (11.3 KB)

8

For joining not required.
For appending it is mandatory.

1 Like
9

I just want to join them with some options.

10

Hey mate @hsupyaewoon
Hope issue has been resolved till now. :slight_smile:
if not, what error you are getting?
On what basis you want to join the tables… is it Approve person code and employee number.
did you trimmed the column data before joining.

1 Like
12

Heyyy @SaurabhDisawal
Nice to see you again.
It isn’t solved till now.
First,I want to join “Holiday taken” from holiday taken file(CSV) and “holiday must take” from trial4(EXCEL).
But when I try to join them, nothing came out.
And the second is “Approve Person Code” from approver file(CSV) and “employee number” from the datatable of the first join.
But, I didn’t trim the column data.
And I trimed it now.
Yet, as I told you, since the first join, there was no data in the datatable and so also none of the result came out in the end.

13

@hsupyaewoon
In the trial4 excel i can see only one cell with data, on which basis you want to join the data, can you share expected result for 1st join?

1 Like
15

Yes @SaurabhDisawal
There is only one cell.
I want to join like this.
image

image
image1322×667 93.4 KB

16

@hsupyaewoon

nopes, share it in excel format, by updating excel manually.

1 Like
18

Ok so, you just want to copy that data to each row in Holiday taken datatable
That is not possible with Join, because for join we should have a common column in both the tables, like we have Approve Person Code and employee number in other scenario.

You can use Add data row and add that value in other DT
wait 10 mins i will share the xaml.

1 Like
19

@SaurabhDisawal
Thank you for your answer.
Yes, I am waiting. :blush:
Actually i don’t want to copy the data. :cry:
Like there may be some employees who already took more than 3 days and so, I don’t want their data. I want employees who only takes less than 3 holidays.
May be sometimes, less than 5 holidays. It depends on the condition.
That’s why I am stuck.

20

ooh ok cool, i will make the changes

1 Like
21

Thank you so muchhhhhhh @SaurabhDisawal… :sob: :star_struck:

1 Like
22

@hsupyaewoon
Basically you wanted the Holiday taken Dt to be filtered out for the employees who have not taken the hoildays mentioned in another DT.
Check this xaml it will give u the filtered data in “FilteredTable” DT and then you can join the Approver table as before we did.
new (1).xaml (8.1 KB)

2 Likes
23

@SaurabhDisawal
I got it. :heart_eyes:
Thank you so much… :heart:
I really appreciate it…

2 Likes