BookmarkSubscribeRSS Feed
lev
Calcite | Level 5 lev
Calcite | Level 5

Hi Everyone,

 

I have a DI Job that I want to modify. I have to include an additional Join before a Table Loader node, but when I modify the connection to that Table Loader, the mappings of columns to the target table are lost. How can I set the Table Loader (or any other) node to preserve the mappings that are already set? It is very annoying that in this situation I have to reconnect all the mappings I set before the modification of the job. (I use the Jobs with Automatic propagation and Auto mapping turned off.)

Any help appreciated!

Best Regards,

Levente

2 REPLIES 2
LinusH
Tourmaline | Level 20
Not sure you can.
In some situations (I haven't been able to figure out the "rules" around this) these steps might preserve mappings:
- add new transform, connect and map columns
- move the the existing connection from the original source to the new transform.
Either way, this actually deserves a ballot entry...
Data never sleeps
lev
Calcite | Level 5 lev
Calcite | Level 5

Thanks for the answer LinusH!

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1117 views
  • 1 like
  • 2 in conversation