Siang master", mau tanya
ada yg pernah merger 2 datatable yg berbeda jadi satu? pakai activity merger datatable hasilnya malah seperti ini
terima kasih
Siang master", mau tanya
ada yg pernah merger 2 datatable yg berbeda jadi satu? pakai activity merger datatable hasilnya malah seperti ini
terima kasih
Welcome to our UiPath community.
The above two DataTables doesn’t contain any common columns because of that you are getting such output.
If there is no common columns between two DataTables and you know the last column in the first column then you can try below way.
Use Read Range activity to read the second DataTable. Let’s say dtInput.
And then use Write Range activity two write into First excel file and pass DataTable as dtInput and Range as “E1”.
Halo,
memangnya anda ingin output yang seperti apa?
Hello,
yes it’s the last alternative, but is it possible without excel, only using datatable ?
Halo,
Outputnya ingin seperti gambar kedua ,
kendalanya ada 2 datatable ingin di merger namun hasilnya seperti gambar pertama.
Hi,
thank for your input. \you are correct that merge 2 Datatable must have similar header columns.
i guess UiPath need to put more information regarding this condition because I cannot find it on https://docs.uipath.com/activities/docs/merge-data-table
Regards,
If you want to merge both the data tables, Use Merge Datatable activity provided by UiPath and in the properties panel Select Add option in Missing schema option.
Thanks
_test (1).xaml (33.7 KB)
ini untuk workflow nya,
baca jumlah colom data excel 1
ubah jumlah colom+1 ke alphabet
tulis datatable 2 dengan range colom+1 yg sudah jadi alphabet
bisa di ultilasi pakai invoke workflow biar ga panjang ,
dan covert ke alphabetnya masih belum optimal
but heyy it works la haha
reference
@jessbrian yang membuat konversi
regards
ahmad
you are correct but the output is not what i expected, you can see from 2nd picture.
what output do you want?
Thanks
heres solution from @AndersJensen
it can produce the output with 2 datatable diffrent column
Main.xaml (8.4 KB)
test - Copy.xlsx (7.8 KB)
test.xlsx (9.2 KB)
but you cannot have same excel header ya
HI @pravin_calvin if you have any better solution it will be very helpful , caused even i cannot seems to find the perfect answer for this
Hi @Ahmad_Rais
Have a seen on the xaml that you have provided its seems its reliable approach!
Regards
Thank you !
terima kasih atas solusinya master.
ini udah sesuai yang gw harapkan.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.