We have cases there source data format differs from target data format:
- Naming of the columns can be different
- Order of the columns can be different
- Target format may have more columns than source
- Target columns may be composite of two or more source columns
While this can be done using standard nodes such as reorder, calc, modify fields we are still lacking dropdown functionality.
We have developed a small helper library node for automatically creating scripts for Transformation node.
Operation is simple: User connects and runs target data/schema into library node AND copy-pastes contents of the ConfigureFields and ProcessRecords outputs to a Transform node.
This enables dropdown-style of mapping between the source and target formats (unicode but can be extended)
Zip file contains the library node, example dataflow and files.
Feel free to use.
This is somewhat related to an older discussion: Input based Drop-Down Property for Transform Node
------------------------------
Markku Rantala
Product Manager
Adsotech Scandinavia Oy
Espoo
------------------------------