span8
span4
span8
span4
I have a list of observations where the assetID may appear a number of times,so I have added an "Increment" attribute that I want to populate with 01,02,03,04 which will recurr with each change in assetid.I can do this in excel,by using the if statement looking at the row above.=IF(A2=A1,B1+1,1) how can I do this in FME?
My data looks like this - and want to add the suffix which I have added manually here as an exampleInspection | suffix to add |
WW2016012017846 | 01 |
WW2016012017846 | 02 |
WW2016012017846 | 03 |
WW2016012017846 | 04 |
WW200012065234 | 01 |
WW200012065234 | 02 |
WW200012065234 | 03 |
WW200012065234 | 04 |
WW200012065234 | 05 |
WW200012065234 | 06 |
See above - you need to use a Counter,with the Counter Name set to your attribute.Then pad the string,and concatenate it,and Bob's your uncle.
Alternatively the StringFormatter can also be used instead of the StringPadder.
© 2019 亚搏在线Safe Software Inc |Legal