Joining two datables of CSV and Excel

@hsupyaewoon,

Are you facing any error?

1 Like

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

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

Regards,
Karthik Byggari

1 Like

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

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)

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)

For joining not required.
For appending it is mandatory.

1 Like

I just want to join them with some options.

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

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.

@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

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

@hsupyaewoon

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

1 Like

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

@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.

ooh ok cool, i will make the changes

1 Like

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

1 Like

@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

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

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.