ChrisBurks
Giga Sage

Hi @Colleen Lowe ,

Let me see if I understand correctly what the ask is.

You have structured the generic look up table already with the columns shown in your last post. In your prior post you're asking how to get the required information into the generic look up table, such as populate the cells that contain the question marks displayed in your post. Is that correct?

 

If my assumption is correct a data source flat file (CSV, Excel, JSON, XML etc.) can be used to import and populate the table. It can also do a direct database connection to a third party database to grab the data needed. 

Here's the ServiceNow documentation on setting up a Data Source:

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/c...

 

There is also a feature known as Easy Import:

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/c...

 

As well as the "Load data" module that guides you on loading a flat file similar to the Easy Import feature:

ChrisBurks_0-1752207593536.png

 

Hopefully, I understood the question and this helps you.