Renaming first attribute(s) in exampleset based on position, not name.

kayman

Hi there, I have a few inconsistent datasets due to some legacy styles when importing excel files. Typically my files contain 5 standard attributes (first 5 in the example set) and then one to indefinite additional attributes/columns

 

The problem is that attribute/column one and 2 are occasionally named incorrect without any real pattern behind, so the idea is to rename my first attribute just as "A" and my second attribute like "B". But I can't find a real way to rename an attribute based on it's position in the set, plenty of other ways if you know the name but that's the problem in my case. I thought of looping the set but also here there seems no real easy way to understand the actual position of the attribute.

 

Any advice?

Telcontar120

Maybe I don't entirely understand your problem, but doesn't "Rename by Generic Names" do what you want?  You specify the "root" ("att" by default) and then it appends a number which corresponds to the position in the dataset.  As usual you can apply to all attributes or filter for the ones you want using regex, value type, or just a list of specific ones.