I have a question about profiling.
I need to analyze a dataset that involves the following case study:
In the Trade Finance area of a bank we have transaction data in Excel. The Excel file contains information such as transaction ID, booking country, type of trade (Export, Guarantee or Import), Beneficiary, applicant, Goods, Amount, Currency, Beneficiary country, applicant country, port of origin, port of destination, origin of goods, client risk and country risk.
The question here is whether you can have a kind of 360 degree customer view with the help of this data or what you can do with this data. I thought of pattern recognition in which I visualize the relationship between Beneficiary and applicant. If our customer has always sent his contractual partner the same type of products on average or the price has moved within a certain level, a kind of detection should take place, which can then tell me whether something is wrong with the transaction. The same applies if you have sent the goods to the contract partner for years via the same route and then suddenly use a different shipping route. Is this use case possible in KNIME?
I already started to prepare the data, but have a question to “Strings to Document”. The column “Beneficiary” is filled with a company name as Siemens AG and only the column “goods” is filled with different ways of description like “boys pullover”, “chemicals Pharm” or “baby goods” and also longer descriptions. Should I apply “Strings to document” just for the column goods?
If not, how can I use a Strings to document node for more than one column?
Thank you for your ideas and help