Skip to main content
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

hkingsbury
Celebrity
Forum|alt.badge.img+54
  • Celebrity
  • March 13, 2023

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


  • Author
  • March 13, 2023
hkingsbury wrote:

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!


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • March 13, 2023

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

image 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings