9061.K.1_​Belgium_​AnaCredit_​CEP_​stage_​3_​test_​version_​2

0 ×

Pre-requisites to run this workflow -

1)Input files should be in .xlsx format only
2) Please enter the report date if required. For example output required for a particular yyyy/mm/dd needs to be entered in the report date.
3) Before running the workflow, all the files should be closed.


Please do not change the sheet Name/Tab Name (Case Sensitive) in the existing file. Data should be pasted into input file as it is, in the same row and columns order.

Output files will be created in output folder. Output of this file is to be used in Part II.

Output Name:

*AnaCredit_YYYYMMDD (Un, YYMMDD is the datestamp of the workflow run)

Nodes

• String Manipulation29 ×
• String Manipulation (Variable)11 ×
• Row Filter10 ×
• Column Filter7 ×
• String Configuration7 ×
• Merge Variables5 ×
• Rule Engine Variable4 ×
• Table Creator4 ×
• Boolean Configuration3 ×
• Concatenate3 ×
• Column Rename2 ×
• Component Input2 ×
• Component Output2 ×
• Create File Name2 ×
• Cross Joiner2 ×
• Extract System Properties2 ×
• Merge Variables2 ×
• Table Row to Variable2 ×
• Variable to Table Row2 ×
• CASE Switch End1 ×
• CASE Switch Start1 ×
• CSV Writer1 ×
• Catch Errors (Data Ports)1 ×
• Create Date&Time Range1 ×
• Excel Reader1 ×
• Excel Writer1 ×
• Extract Context Properties1 ×
• Java Snippet1 ×
• List Files1 ×
• RowID1 ×
• String to Path (Variable)1 ×
• Table Column to Variable1 ×
• Table Column to Variable1 ×
• Table Row to Variable1 ×
• Try (Data Ports)1 ×
• URL to File Path1 ×
• Unpivoting1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Basic File System Connectors
• FeatureKNIME Excel Support
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• Convert an .xlsx or table in knime to a xml file. As pert the xml format(present in a xml reference file)

  forum.knime.com/p/247447