Skip to main content
Question

How can i modify FME Quick translator ,looking for name inside the excel source file

  • February 14, 2020
  • 4 replies
  • 18 views

gogopotter90
Contributor
Forum|alt.badge.img+13

 

How can i modify FME Quick translator .i want to add one more connect with source excel file

i want to write field name so it will look for the name of this field in the source excel file and the code will work only depend on this name for each parameter inside the work space ,

so i want to add one more command line called write name on this page .

Thanks for help

4 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • February 14, 2020

I do not think this is an option using FME Quick Translator.

But when you run the same workspace using FME Workbench, you can start with a Tester transform, testing the mentioned attribute Has a Value (= not null, empty or missing).

If the Tester fails, you can follow up using the Terminator, causing the process to stop.

Hope this helps.


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • February 14, 2020
erik_jan wrote:

I do not think this is an option using FME Quick Translator.

But when you run the same workspace using FME Workbench, you can start with a Tester transform, testing the mentioned attribute Has a Value (= not null, empty or missing).

If the Tester fails, you can follow up using the Terminator, causing the process to stop.

Hope this helps.

sure,we have .i saw before oneday on quick translator so i am asking about the idea .how can i do that . and i do not have enough experience for doing that. and thanks for ur reply


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • February 17, 2020

You'd need to make a workspace that does the translation from Excel to Excel using FME Workbench. Then within that workspace you'd need to make a "published parameter" https://knowledge.safe.com/articles/1287/published-parameter-examples.html that takes the field name, and build logic around that. After that you can run the resulting workspace in the quick translator and it will prompt you.


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • February 17, 2020
fmelizard wrote:

You'd need to make a workspace that does the translation from Excel to Excel using FME Workbench. Then within that workspace you'd need to make a "published parameter" https://knowledge.safe.com/articles/1287/published-parameter-examples.html that takes the field name, and build logic around that. After that you can run the resulting workspace in the quick translator and it will prompt you.

Thanks for ur reply . i will try ur suggestion


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings