Hello i want to change the Columnames based on the first value.
Example:
Column: A
first Value: Dog
newColumname: Animal
+50- Celebrity
Do you have a list of criteria? I.e. a list of values for column A that would result in it being renamed to Animal.
redgeographics wrote:
Do you have a list of criteria? I.e. a list of values for column A that would result in it being renamed to Animal.
the criteria would be the first value. So check all columns if it has "dog" as the first value. If yes then rename the column to Animal.
I have two different Date columns so the dates could be same in both columns but in the first row they have different values so i know the column with the 12.03.2020 is Date_A and the other column with 14.02.1990 is Date_B
+50- Celebrity
fluusha wrote:
the criteria would be the first value. So check all columns if it has "dog" as the first value. If yes then rename the column to Animal.
I have two different Date columns so the dates could be same in both columns but in the first row they have different values so i know the column with the 12.03.2020 is Date_A and the other column with 14.02.1990 is Date_B
Yes, it's possible.
- Build a list of all your features (ListBuilder)
- Check if the first list element has attribute value "dog" (TestFilter)
- If so, explode the list to get your original features back (ListExploder)
- Rename the attribute (AttributeRenamer)
I've attached this as a template. Note that if you want to support different animals you should edit the TestFilter.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.