Hi all,
I have a table in Excel that looks like (I have added he Case rows to make it clearer):
I have been asked to concatenate fields when for the same site there are two different countries or two different regions or both, as follows:
Does anyone have an idea of how I could achieve that in FME so that I can get the concatenation done for the three cases?
Best answer by takashi
Assuming that the concatenation should be performed for each Site group (1A, 2Z, and 3W in the example), I would use two Aggregators in a series.
1st Aggregator
Group By: SiteCode, County
Mode: Attributes Only
Keep Input Attributes: Yes
Attributes to Concatenate: Region
Separatoe Character: & (surround by whitespaces)
2nd Aggregator
Group By: SiteCode, Region
Mode: Attributes Only
Keep Input Attributes: Yes
Attributes to Concatenate: County
Separator Character: & (surround by whitespaces)
If you will respect the order of input features, expose "xlsx_row_id" in the Excel reader feature type, and insert the Sorter between the two Aggregators to sort by "xlsx_row_id".
Takashi
Assuming that the concatenation should be performed for each Site group (1A, 2Z, and 3W in the example), I would use two Aggregators in a series.
1st Aggregator
Group By: SiteCode, County
Mode: Attributes Only
Keep Input Attributes: Yes
Attributes to Concatenate: Region
Separatoe Character: & (surround by whitespaces)
2nd Aggregator
Group By: SiteCode, Region
Mode: Attributes Only
Keep Input Attributes: Yes
Attributes to Concatenate: County
Separator Character: & (surround by whitespaces)
If you will respect the order of input features, expose "xlsx_row_id" in the Excel reader feature type, and insert the Sorter between the two Aggregators to sort by "xlsx_row_id".
Takashi
Thanks for your priceless help!
Darius
In addition, try setting "Yes" to "Input is Ordered by Group" parameter of the Aggregators, if rows which contain attributes that should be concatenated are always consecutive. In this case, the Sorter would not be essential to keep the input order.
Thank you I found this very useful, I have started the workbench as seen in the attached, and it is working fine, but the problem that I got simillar value in the row (attached), any Idea how to remove the identical value in the row,
which tool is missing here?
Best,
Majdoleen
Best,
Majdoleen
Thank you Takashi, really appreciate.
Best,
Majdoleen
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
