Question

Rename attribute name from repeating attribute values


I apologize if this has been asked before but I couldn't find anything related.

I have a csv with the following data:

1With no header names. And I'm trying to get the following:

2I'm not sure which transformer to use, I thought BulkAttributeRenamer could help me here but I can't manage to make it work.

I appreciate all your help before hand.


3 replies

Userlevel 5
Badge +29

When you add the csv reader, make sure you Field Names Lines is empty, and your Data Start Line is 1

image 

The attribute names will then come through as col0, col1, col2 etc.

You can then rename these user the attributeRenamer or the attributeManager

When you add the csv reader, make sure you Field Names Lines is empty, and your Data Start Line is 1

image 

The attribute names will then come through as col0, col1, col2 etc.

You can then rename these user the attributeRenamer or the attributeManager

Yeah the problem is that I got tables with up to 100 attributes so I was looking for a solution to not doing manually.

Thank you!

Userlevel 1
Badge +10

One possible way, you would need to Expose the newly created Attributes but that can be done fairly quickly by importing from FeatureCache

image 

Reply