Forum

Notifications
Clear all

Append data to an existing workbook form Service now data

3 Posts
3 Users
0 Reactions
117 Views
(@tonybessent)
Posts: 1
New Member
Topic starter
 

I have service now export where the data has been cleaned and then there is new data and date on older data that changes, but need to be added to the existing data, without having to keep going back and cleaning the data again.

Thus I want o do a service now export yr-2-date and then merge the data but only the data that is new in one column and changed in another column. Eg., The ticket number would be added if new (not existing) then check the closed status column and updated this if it has changed on any of the existing data, and finally if the close notes column has new data change that.

Thus all the old data going back to the start of the year or more than two months ago is not changed.

 
Posted : 08/12/2021 1:12 pm
(@jstewart)
Posts: 216
Estimable Member
 

I'm confused. So if I am looking for ticket #12345 it could be on multiple lines of data and you want to consolidate all the information on one line of data? Am I understanding that correctly? If you are trying to do what I think it sound like you may need VBA. If that is not what your trying to do I need clarification, maybe a sample of generalized data showing what you expect your results to look like.

 
Posted : 08/12/2021 2:00 pm
Anders Sehlstedt
(@sehlsan)
Posts: 973
Prominent Member
 

Hello Tony,

Why don't you simply create a report in ServiceNow? I assume your exports comes from the Incident Management system from ServiceNow ITSM solution.

Anyway, as Jessica mentions, a sample file is needed for us to better understand what you are trying to achieve.

Br,
Anders

 
Posted : 08/12/2021 3:03 pm
Share: