Skip to main content
Solved

How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA

  • April 26, 2023
  • 2 replies
  • 109 views

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.

2 replies

Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • 150 replies
  • Answer
  • April 26, 2023

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)
  • 139 replies
  • April 26, 2023

@Technical Outlaws 

That worked fine.