You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PBCS / FDMEE / Data Mapping problem

edited Jan 9, 2019 12:57PM in Planning 4 comments

Summary

Only pre-pend a character to < X Characters?

Content

I have two separate source files.

 

In one my cost centres are like this; 10110; in the other they are like this; C10110.

 

I need C10110 format

I have 10,000+ codes so do not want to explicitly map.

I am struggling how to add C to 10110 without adding another C to C10110

 

I have a parallel requirement for another dimension for 101, LE101 where again I want them all in the latter format.

 

Possible?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!