Skip to main content
Question

Rename attribute name from repeating attribute values

  • March 13, 2023
  • 3 replies
  • 11 views

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+63
  • Celebrity
  • 1620 replies
  • 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
  • 1 reply
  • 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

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+44
  • Influencer
  • 3422 replies
  • 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