ETL Multiple Input/Output script

[Johan13]

Hi,

I'm using  "Integration hub ETL" and trying to add in additional fields for the output data (for an existing transform). However, I have not been able to do that. I was expecting this to be available in the "Preview and Prepare data" step.

Any advice?

BR/Johan

[AJ-TechTrek]

Hi @Johan13 ,

As per my understanding why you don’t see new fields in Preview and Prepare Data
* The Preview and Prepare Data step only displays fields that:

1. Exist in the Source schema (from your data source).
2. Have been mapped/added in the Transform definition.

* If you add a new field at the target but it’s not available in the source or in the ETL definition, it won’t show up automatically.

Steps to add additional fields in IntegrationHub ETL

1. Check the Source Schema
* Go to your ETL Transform → open the Source Definition.
* Confirm if the new fields exist in the source table/schema.
* If they are not there, extend your connection & schema import so ServiceNow can recognize them.

2. Add the fields in the Transform definition
* In the ETL Transform record → Go to Transform definition tab.
* Click Add Field to include your new fields.
* Map them either to source fields (if available) or create a static/default transformation.

3. Regenerate the ETL pipeline
* After adding, click Preview Schema again.
* Now the field should appear in Prepare and Preview Data.

4. If field is only needed in Target (CMDB or custom table)

* Add it directly in the Transform Map step.
* Use a Scripted Transform (or mapping expression) to populate the new field from existing data or a static value.

5. Re-run the ETL Job
* Run the pipeline again and validate if the new fields appear in the final output.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.
 

Thank You
AJ - TechTrek with AJ - ITOM Trainer
LinkedIn:- https://www.linkedin.com/in/ajay-kumar-66a91385/
YouTube:- https://www.youtube.com/@learnitomwithaj
Topmate:- https://topmate.io/aj_techtrekwithaj (Connect for 1-1 Session)
ServiceNow Community MVP 2025

[Johan13 · Accepted solution]

This is the way I solved it:

In "Integration hub ETL", in the "Preview and Prepare data" step, I had an existing Transform: a Multiple Input/Output Script where I could not define additional Output fields.
I could declare additional Input fields. But not Output fields.

However, and this is important, at the time of creating a new Input/Output script (transform) I found that I can add Output columns.

So in order to change the Output columns one needs to (re-)create a new Multiple Input output script. We have an Xanadu instance, patch 5.