Icon

week2

Reding The files Output Data manipulations For week 2 of our beginner month, Data Source Bank has a requirement to construct International Bank Account Numbers (IBANs), even for Transactionstaking place in the UK. We have all the information in separate fields, we just need to put it altogether in the following order:Input the dataIn the Transactions table, there is a Sort Code field which contains dashes. We need to remove these so just have a 6 digit string (hint)Use the SWIFT Bank Code lookup table to bring in additional information about the SWIFT code and Check Digits of the receiving bank account (hint)Add a field for the Country Code (hint)Hint: all these transactions take place in the UK so the Country Code should be GBCreate the IBAN as above (hint)Hint: watch out for trying to combine sting fields with numeric fields - check data typesRemove unnecessary fields (hint)Output the data swiftcodes.csvtranscations.csvRemoving dashes from sortcodecreating IBANSJoin two csv's filesSelecting IBANS CSV Reader CSV Reader String Manipulation String Manipulation Joiner Column Filter Reding The files Output Data manipulations For week 2 of our beginner month, Data Source Bank has a requirement to construct International Bank Account Numbers (IBANs), even for Transactionstaking place in the UK. We have all the information in separate fields, we just need to put it altogether in the following order:Input the dataIn the Transactions table, there is a Sort Code field which contains dashes. We need to remove these so just have a 6 digit string (hint)Use the SWIFT Bank Code lookup table to bring in additional information about the SWIFT code and Check Digits of the receiving bank account (hint)Add a field for the Country Code (hint)Hint: all these transactions take place in the UK so the Country Code should be GBCreate the IBAN as above (hint)Hint: watch out for trying to combine sting fields with numeric fields - check data typesRemove unnecessary fields (hint)Output the data swiftcodes.csvtranscations.csvRemoving dashes from sortcodecreating IBANSJoin two csv's filesSelecting IBANS CSV Reader CSV Reader String Manipulation String Manipulation Joiner Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: GIRI PRASATH
Created at: 2024-02-08
On NodePit since: 2024-02-09
Last update: 2024-05-05
Created with KNIME version: v5.2.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!