DT1 and DT2
here iam write the data table from dt1 and dt2 using join data table but after writing it the aline ment is not as expected hsncode values underthat and terms of delivery = values [below that only
please see my flow
Hi community,
Can any one help on this please
hello,
any one is availble to help me please
Hie @Naveen_Kanike use this linq method to join datatables it quick and also take less activity which increase your project efficiency…
dt1- output of first datatable
dt2- output of second datatable
dtoutput-help to store the output of two join datatable value which you want to write
cheers Happy Automation…
You’re doing a lot of unnecessary things here. You don’t have to Build Datatable before Read Range. Read Range builds it for you. And Read Range puts the data into a datatable, you don’t have to then loop through it and re-add it to the datatable.
You’re doing a full join, which may not be what you want. It’s more common to do a left join, which means keep all records from the first dt and pull the matching data from the other dt.
Naveen , you need to be using proper join type based on the data you need . Full join is not giving you the expected results , due to null ( as a result of join ) you are getting blank cells in excel output .