Skip to main content
Question

Newbie - Split Access table's fields to add transformers on specific fields

  • October 9, 2019
  • 5 replies
  • 31 views

acusig
Participant
Forum|alt.badge.img+1

As question title mention it, I would like to split an Access table's fields to be able to connect transformers on several fields in order to achieve date formating.

I've been able to connect one field (DConseil) but I wonder how to connect specific transformers on the others date fields and let them work simultaneously, if it's possible.

I've tried several times to redirect features through spliting, filtering, testing, and so on but I'm certainly thinking the wrong way.

To keep it simple : how can I achieve a "routing" before adding transformers on each ports.

Sorry for any duplicate but I didn't find any valuable answer to my problem for now.

Thanks in advance for any help.

Pierre.

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

bwasserstein
Participant
Forum|alt.badge.img
  • Participant
  • 20 replies
  • October 9, 2019

I'm not certain I fully understand what you're trying to do, but try using a TestFilter rather than just a tester. A tester only allows you to perform one test, whereas a TestFilter allows you to perform multiple conditional tests & to set up multiple output ports within a single transformer.

You can also explore the AttributeFilter and AttributeManager transformers.


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • October 9, 2019

Hi @acusig,

The data read into the workspace contains all the attributes, if you need to transform one attribute, you don't need to split the table and keep that single attribute.

For example if you need to convert a date attribute, you can read the table features and use a transformer (DateTimeConverter) to convert the attribute values of that specific attribute you set the transformer for:

I hope this makes sense.

Itay


acusig
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • 11 replies
  • October 10, 2019

Thank you for your answers @itay and @bwasserstein, but I do apologize, my question was a bit unclear.

TestFilter is close to the solution but allows only one IF statement where I need multiple ones.

I placed another schema here under to be more explicit. "Direct connections" try to mimic the way I would adress a specific transformer to a specific field.

 


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • October 10, 2019

Thank you for your answers @itay and @bwasserstein, but I do apologize, my question was a bit unclear.

TestFilter is close to the solution but allows only one IF statement where I need multiple ones.

I placed another schema here under to be more explicit. "Direct connections" try to mimic the way I would adress a specific transformer to a specific field.

 

Have a look at the AttributeCreator or AttributeManager for conditional statements (If else than...)


acusig
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • 11 replies
  • October 10, 2019

Thank you for your answers @itay and @bwasserstein, but I do apologize, my question was a bit unclear.

TestFilter is close to the solution but allows only one IF statement where I need multiple ones.

I placed another schema here under to be more explicit. "Direct connections" try to mimic the way I would adress a specific transformer to a specific field.

 

Thanks @itay, AttributeManager with conditional statements seems to do the tricks.

Have a nice day gentlemen, you make mine !