Skip to main content

Below is the example file where I am getting all my data from. As you can see, each row has a unique ID and there are 4 sets of product information.Example1What I am trying to do is create a single row for each set of product and ensure that the ID and User ID matches. Example below Example 2Any help will be greatly appreciated. Thank you

@francoconv​ Welcome to the FME community.

Possibly the easiest approach is to attached 4 AttributeManager transformers (in parallel not in series) to your Excel reader Feature Type, and then rename each of the attributes. i.e.

Product Item 1 -> Product Item

Product Description 1 -> Product Description .

There is also a BulkAttributeRenamer that will let you remove a Suffix. So again, attach four BulkAttributeRenamer transformers )in parallel) and remove the suffix " 1" etc.


@francoconv​ Welcome to the FME community.

Possibly the easiest approach is to attached 4 AttributeManager transformers (in parallel not in series) to your Excel reader Feature Type, and then rename each of the attributes. i.e.

Product Item 1 -> Product Item

Product Description 1 -> Product Description .

There is also a BulkAttributeRenamer that will let you remove a Suffix. So again, attach four BulkAttributeRenamer transformers )in parallel) and remove the suffix " 1" etc.

Thanks so much for this. Will give it a go and report back.

The excel file that I will end up using has 51 sets of product information. Is there another option other than then using 51 AttributeManager transformers?


@francoconv​ It's easier to explain these things if you can include sample data. But if you know how many products you have, then you can use the Cloner to create a separate feature for each 'product' and then feed all of those into a BulkAttributeRenamer, and parameterize the suffix to remove (i.e the value of the suffix can come from an attribute.


Reply