i have some cells contains
Aaaa||ccc||ddd||bb||fff
i would like to reverse them in case condition happens to get
fff|||bb||||ddd||ccc||Aaaa
FME 2021
Thanks in advance
Solved
how to reorder values in some cells ?
+3- Contributor
Best answer by geomancer
If I understand correctly, you have some data in one attribute, where you want to invert the order of the words. It is not clear why there are extra | characters in your desired results, I ignored those for now.
- Use an AttributeSplitter to split the attribute into a list on ||
- Explode the list to individual features. This gives you an attribute _element_index that gives the order the features had in the list
- Sort on that attribute in descending order
- Aggregate the features in an Aggregator, concatenate the attribute that came from the list.
+47- Evangelist
- Best Answer
If I understand correctly, you have some data in one attribute, where you want to invert the order of the words. It is not clear why there are extra | characters in your desired results, I ignored those for now.
- Use an AttributeSplitter to split the attribute into a list on ||
- Explode the list to individual features. This gives you an attribute _element_index that gives the order the features had in the list
- Sort on that attribute in descending order
- Aggregate the features in an Aggregator, concatenate the attribute that came from the list.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.