Hello everyone, if somebody has some ideas, it would be great. I have 2 excel files. In the first one, I got attributes: indicator_id, indicator_name, iso3, country_name, 1990, 1991, 1992..., 2017 and in the second one I got attributes: ID, Country, Year Deaths, Deaths, Year Birth, Births. I need to get one excel that looks like picture 3 where indicator_name get in the column and all that has to be based on the year (picture one for Afghanistan is 2015 so we have to take the data from the same year from picture 2 ). Thanks.
Question
Create new excel based on 2 excel and based on few rules
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2- Contributor
Hi @maloks,
Not sure how you are currently calculating the Adjusted net savings, adolescent birth rates, etc. in the third image, but there are likely a few ways you can accomplish this task.
Are you able to upload a small sample of the source dataset(s) and the formulas you are using to calculate these values? I'd be happy to provide you with more detailed instructions if you are able to provide a bit more information. You should be able to perform all of the calculations in FME using an ExpressionEvaluator; however, if you prefer to use excel formulas we also support writing those - as noted in the Working with excel writer article.
I see the FeatureJoiner, AttributeManager, ExpressionEvalutor, and ExcelStyler being the main transformers used in this case.