I'm transforming a number of geographic tables from one MCD to another, so I'm using FME (I'm new to FME). I can map 80% of my fields with out any problem (MCD_A.fld_1 = MCD_B.fld_1) but in the in the second MCD I need to generate a new PK based on a concatenation of a string and a three digit increment something like 'BBBSYN_'||Increm.
I've tried generating the value directly in the FME writer (Feature Type -> User Attributes -> Value -> text Editor (see below) using @Count() - but this only generates simple increments '1','2','3' - I need '001', '002' etc. Also I already use @Count in another field and FME seems to confuse them both, i.e. in fld_1 and fld_2 of the same feature, count results in fld_1 = 1 and fld_2 = 2, not ideal.
I've looked through the safe website and the youtube channel - which is full of useful stuff but it's like finding a needle in a haystack - I also found this on SE : How to create autoincrementing primary key with dynamic writer in FME
Which looked like it would solve at least part of the problem - but it's a couple of years old and I don't have same options available in my feature type dialog box (I can't set type to identity or index to primary key for example) - I'm using FME 2019 and this post is over two years old so i'm guessing they're not using FME 2019...
This is probably incredibly easy (it really should be...), but I can't find the right function ?