Hi @gustavodc3684, Swift MT940 format is not one that is pre-built into Alteryx. It would require inputting in text form before parsing with regex or text to columns (so you'd need to know the data structure, and understand how to parse it). A lazier-but more complex-solution is to parse the file with a python tool using a library designed to parse MT940. Then extracting the information you need, or just outputting the parsed data in JSON (you can then parse the data in with its JSON tool). Hope this helps!
Great video thank you😃
Thnaks! I have a question. Do you know how import a bank file (format Swift MT940)? :)
Hi @gustavodc3684, Swift MT940 format is not one that is pre-built into Alteryx. It would require inputting in text form before parsing with regex or text to columns (so you'd need to know the data structure, and understand how to parse it). A lazier-but more complex-solution is to parse the file with a python tool using a library designed to parse MT940. Then extracting the information you need, or just outputting the parsed data in JSON (you can then parse the data in with its JSON tool). Hope this helps!