Hello,
In my automation, i have read 2 different excel files and created 2 different data tables (DT1 and DT2). using the directions from this post, Join Two Data tables with Different Columns and Different Data - #4 by Tapan_Behera1, i was able to successfully add the DT2 information in a new column in DT1(Dt_SNServers in my automation). I wanted to add to this activity by putting in inside of an excel application scope (using classic) and then append the new DT1 with 2 columns to a new spreadsheet. below is a screenshot of my sequence. i’m getting no errors when i run the automation and getting results in the “write line” activity, but when i open up the excel file to see if any information has been recorded, it returns blank. Am i missing an activity to convert my newly created DataTable (Dt_SNServers) back in an excel file?
I’m not sure what i need to be more specific about? I have 2 Data tables that each only have one column of data. I combined DT2 with DT1 and now DT1 has 2 columns of information. Column 1 is ServiceNow Servers and Column 2 is Solar Winds Servers. I’m wanting to append DT1 into an excel file that shows my 2 Columns of Data.
right now, with my automation as is, it will run, but no data is collected in the new excel file.
You can do it easily with the Modern Excel activities,
→ Use the Use excel file activity and pass the Excel1 file path.
→ Use the another Use excel file activity and pass the Excel2 file path.
→ Inside Second Use excel file activity insert the Copy\Paste range activity.
It will easy to copy and paste the whole column in Excel1.
Check the below workflow for better understanding,
