Skip to main content
Solved

How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA? I have a Source column and I want to force UPPERCASE on import of data, how can this be done? Is it done at the Method attributes?

 

 

Best answer by Technical Outlaws

The Source Column in Source Mapping can handle SQL commands, so in your case you can just use UPPER(CF$_BRANDPARTNO) in the Source Column.

View original
Did this topic help you find an answer to your question?

2 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

The Source Column in Source Mapping can handle SQL commands, so in your case you can just use UPPER(CF$_BRANDPARTNO) in the Source Column.


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 134 replies
  • April 26, 2023

@Technical Outlaws 

That worked fine. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings