Skip to main content
  • EN

Hi community,

I have a very complex challenge. I have a csv with an unknown set of (dynamic) attributes. I was asked to rename the attributes so everything from the dot is removed. That is very easy I would say with the BulkAttributeRenamer (BAR), but then I found out I get duplicate attribute names and this is not allowed in the BAR. I asked what to do with these duplicates and they said I have to sum the attributevalues if there are duplicates.

So for instance I have and attribute xxx17.1 and xxx17.2 the result must have an attribute xxx17 and the values have to be summed. This is no problem with a fixed schema, but I have a dynamic one and I have no idea how to do this. I have attached an example csv. All ideas are welcome.

Thank you.

 

 

Struggling to think of a non python solution

Struggling to think of a non python solution

I have no experience with python so I hope you can find a non python solution.

I have no experience with python so I hope you can find a non python solution.

Have you already got a method of defining the dynamic schema? I think an Attribute Exploder can probably work here

Capture

Reply


Community Stats

30,189
Posts
114,582
Replies
37,854
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.