Solved

Generating a new primary key based on a concatenation of a string and a three digit increment

  • 15 September 2020
  • 2 replies
  • 8 views
L

I'm converting a batch of shp from one MCD to another. I can easily map 80% of the fields without any problem. But for the output MCD I need to generate a new primary key based on a concatenation of a string and a three digit increment. I've tried modifying the value (in the feature type dialog box) using the text editor, and 'string_'@Count() - this sort of works it produces 'string_1' etc but i need 'string_001' etc. Also, I already use Count() in another field which seems to confuse FME - This is probably very easy, but I'm new FME...

icon

Best answer by redgeographics 15 September 2020, 12:37

View original

2 replies

redgeographics
Rank
Userlevel 5
Badge +25

You can add a Format function to it, like this:

string_@Format(%03d,@Count())

This will left-pad the count with zeroes to 3 characters.

L

You can add a Format function to it, like this:

string_@Format(%03d,@Count())

This will left-pad the count with zeroes to 3 characters.

Thanks that helped a lot!  

To summarize:

I started with  string_@Format(%03d,@Count()) - but I still had problems as I used multiple instances of Count() in the table. 

So in end I used a Counter before my file writer (to avoid using Count() multiple times. So in the end I  used this:

'string_@Format(%03d,@Value(_count))'

 

Reply


Community Stats

28,724
Posts
109,517
Replies
36,562
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.