Hi everyone. I am very new to FME. I am trying to copy data from one excel file to another but the new file is formatted differently

@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.