Skip to main content
Question

How to Split the attributes based on count and insert it into Oracle

  • July 11, 2019
  • 1 reply
  • 43 views
M
Forum|alt.badge.img

I have FGDB file with 200 attributes. But i want to split the parts and insert them into oracle table.

Split 1 : First 70 (1-70)insert into oracle.

Split 2: Second 60 (70-130) records insert into oracle.

Split 3: remaining all are insert into oracle.Here the oracle tables are different.

 

I need the suitable solution for this.How can i do this by using FME workbench. In real time data there are lacks of records are there we need to insert step by step.

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.

1 reply

D
Forum|alt.badge.img
  • danullen
  • 104 replies
  • July 11, 2019

Do you mean 200 records or 200 attributes? If it's 200 records, then you can use a Counter on your source data and then split it to three different destinations in a TestFilter according to the count attribute. Count<70, count>130, Else.

Community Stats

32,080
Posts
121,818
Replies
39,714
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.