Are you facing any error?
Can you show more details about it …why it doesnt work out ? di you encounter an error ? @hsupyaewoon
cheers
Happy learning
Check the both data tables have same number of columns and also matching data types.
Regards,
Karthik Byggari
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.
I just want to join them with some options.
Hey mate @hsupyaewoon
Hope issue has been resolved till now.
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.
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?
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.
@SaurabhDisawal
Thank you for your answer.
Yes, I am waiting.
Actually i don’t want to copy the data.
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
@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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.