Skip to main content
Open

for feature type table handling - Truncate if exists - create if needed

Related products:Integrations
  • March 29, 2018
  • 3 replies
  • 137 views

mikem
Contributor

for an output table (in my case esri sde) could you add the option to "Truncate - Create if Needed" i seem to come across this need somewhat often

3 replies

lucky
Contributor
Forum|alt.badge.img+1
  • Contributor
  • July 20, 2018

This is really necessary!

Older Versions of FME automatically created a FeatureClass (Table), if it didn't exist!

So I could handle with "Truncate first" in older Version!

With the new Table Handling I must know if a table exists or not:

when I use "Truncate Existing" - FME does not create the table if it does not exist!

when I use "Create if Needed" - FME does not truncate it!

when I use "Drop and create" - FME-Writer stops with an error if it exists and someone is connected to the table.

So you are right: "Truncate and create if Needed" could solve this Problem!


ranga_tolapi
Contributor
Forum|alt.badge.img+11
  • Contributor
  • September 17, 2020

"Truncate Existing or Create If Needed" is very much required.


oscard
Influencer
Forum|alt.badge.img+23
  • Influencer
  • January 18, 2021

The "Truncate Existing or Create if Needed" would save me a lot of headaches