JSON Relational File Creator

Inputs a json file and generates one or more json files representing the flattened structure of the original file. The flattened files containing embedded GUIDs to enable subsequent linking up with the "parent", which will assist with turning the json into a relational data model.


@takbb Brian Bates 21 April 2023

Options

Input file

specify the json file to be processed

File Concept/Entity

Specify the concept/entity name represented by this json file

Output Folder

Specify the output folder

Filename parent id extraction regex

Enter a regular expression for extracting parent id from filename. Leave empty if there is no id to be extracted from the file name

Parent concept name

Enter the name of the parent concept for this file concept

Parent concept Id

Enter the id of the parent, if not present in the file name

Nodes

• String Configuration6 ×
• String Manipulation (Variable)2 ×
• Component Input1 ×
• Component Output1 ×
• Create Folder1 ×
• Merge Variables1 ×
• Python Edit Variable1 ×
• String Replacer1 ×
• String to Path (Variable)1 ×
• Table Row to Variable1 ×
• Variable to Table Row1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Python 2 Integration (legacy)
• FeatureKNIME Quick Forms

Links

• No links available