Skip to main content
Solved

How do I force UPPERCASE in Data Migration type MIGRATE_SOURCE_DATA

  • Apr 26, 2023 4:13 PM UTC
  • 2 replies
  • 159 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.

View original

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)
  • Apr 26, 2023 4:36 PM UTC

@Technical Outlaws 

That worked fine.