Skip to main content
Question

Creating a field and inserting financial date (dependent on date value)

  • June 24, 2013
  • 5 replies
  • 94 views

Hi guys,

 

 

I am new to FME and wondered if there was a way to fill a field, by querying the date field, and inserting the relevant financial year.

 

 

In SQL you would use something like SELECT * FROM tblCustomers WHERE date >= '01/04/2012' AND date<= '31/03/2013'

 

 

Please advise?

 

 

Thanks,

 

 

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

5 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • June 24, 2013
Hi,

 

 

Have a look at the attribute creator, you can design your tests in it.

  • Author
  • June 24, 2013
So Itay,

 

 

You would create an attribute i.e. the financial year field and then conditionally assign a text string based on a few conditions, for example:

 

 

1. Use the conditions above to filter the data

 

2. Assign a text value when the conditions are true

 

3. Add the text value to a new field

 

 

Could you describe the process to me in via AttributeCreator.

 

 

Sorry, I really am a novice.

 

 

Cheers,

 

 

Gary

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • June 24, 2013
Hi Gary,

 

 

The following Evangelist  article describes in details the use of this new functionality, I hope it is enough to get you started!

 

 

Cheers,

 

Itay

ebygomm
Evangelist
Forum|alt.badge.img+49
  • Evangelist
  • June 24, 2013
Worth noting that the functionality described in the evangelist article is only available if you have updated to SP1

  • Author
  • June 25, 2013
Hi Itay,

 

 

Thanks very much! Second model built and these methods are really handy to have in an FME users' toolkit.

 

 

Have a good day!

 

 

Cheers,

 

 

Gary