Hi,
I want to append “Location” column from Sheet2 to Sheet1.
I have shared some snapshots for reference
Final Solution Be Like -
Thanks,
Rishi
Hi,
I want to append “Location” column from Sheet2 to Sheet1.
I have shared some snapshots for reference
Final Solution Be Like -
Thanks,
Rishi
is there any other columns other than location in sheet1?
No Only One @Lak_Ui
you have to used join activity for adding the specific column in the final sheet.
is there any column common in shee1 and sheet2?
No there is no common @Lak_Ui
TEST.xaml (9.3 KB)
see this example @Rishik_Chowdary
test.xlsx (9.1 KB)
Try this
Hope this Helps
Regards
Sudharsan
Thanks @jack.chan
But when i was opening xaml it was not opening like it was showing it doesnt exist or private
probably your packages are different version. @Rishik_Chowdary
can you send me your xaml as a zip? then i will add it there
If Possible you can share me the screenshot of the code… so that i can understand @jack.chan
use filter datatable and specify the column you need in sheet1
and use write range activity to write the filtered dattable from C1
read sheet1/sheet2 into datatable variables
add data column (“Location”) to sheet1Table
loop over sheet2 (sheet2 Datatable)
in each iteration, set
sheet1.Rows(index)("Location") = CurrentRow("Location")
write updated sheet1 table back to sheet1
@Rishik_Chowdary
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.