Skip to main content
Solved

Is it possible to adjust the values of Table Handling (Use Existing or Truncate Existing) in a flow

  • October 19, 2023
  • 3 replies
  • 38 views
scootercat_nl
Contributor
Forum|alt.badge.img+5

attribuut : Oracle Non-Spatial Writer

parameter : Table Handling (Use Existing/Truncate Existing)

 

Is it possible to adjust the values ​​of Table Handling (Use Existing or Truncate Existing) in a flow?

 

In a daily data dump, there can be a mutation file or an initial file per table (csv file).

Based on that I want to determine Table Handling.

 

This will save a lot of work. Now I still use 25 CSV files out of more than 100. This may increase in the future.

 

For example, of those 25 files, 5 can be initial files and 20 can be mutation files.

 

It will be written to Writer Oracle Non-Spatial.

For the Feature operations I use fme_db_operation.

 

I hope my question is clear.

 

Thanks in Advance

Best answer by nielsgerrits

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.

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.

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+61
  • nielsgerritsVIP
  • Best Answer
  • October 19, 2023

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
danilo_fme
scootercat_nl
Contributor
Forum|alt.badge.img+5
  • scootercat_nlContributor
  • Author
  • Contributor
  • October 23, 2023

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.

thanks for your good tip

nielsgerrits
VIP
Forum|alt.badge.img+61

thanks for your good tip

cheers :)

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...

Community Stats

32,120
Posts
121,954
Replies
39,772
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.