I have used String Searcher to find data with the name BORDER
However,
I am struggling finding the right transformer which will combine the two records into 1 :
this is based on number.
ie - combine
40_BORDER_QB
40_QD_BORDER
then rename the record afterwards
to : ie - 40_QD_QB
this will also have to be done for 65_GF_CR and 67_GF_CR
then merging with Provider data.
Try using the Aggregator, setting an attribute storing the number to the Group By parameter.
thank you Takashi!
how do i store the number to the Group By? It only lets me add in my field name
Try using the Aggregator, setting an attribute storing the number to the Group By parameter.
@takashi let me know if you can explain more, see my post above. thanks!
thank you Takashi!
how do i store the number to the Group By? It only lets me add in my field name
If every StationSeriesName always begins with its number (some consecutive digits), you can extract the number with a StringSearcher and store it into a new attribute (e.g. called "_number"), as in:
If every StationSeriesName always begins with its number (some consecutive digits), you can extract the number with a StringSearcher and store it into a new attribute (e.g. called "_number"), as in:
it is taking all the records though, I want only the 6 records which are then merged to 3 records
40_QD_QB , 65_GF_CR and 67_GF_CR
