Skip to main content
  • EN

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯

The data originates from JSON files, and I need to write it into several csv files.

The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!

The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.

I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.

Any help will be much appreciated.

Stuart

In a FeatureWriter, you can set the target format to CSV, then import the schema from a different source by choosing “Import from Dataset...” You can then select source files.

 

Thank you Niels, that is just what I am looking for, and it works perfectly. 😁

Cheers!

Reply


Community Stats

30,149
Posts
114,438
Replies
37,793
Members
Terms & ConditionsCookie settings
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.