Hi folks,
I have a use case where there's about 600 emails with standard data tables in them, goal would be to have Alteryx read each one and pull the data out if it exists in that weekly email and make one data table. Originally they are created in .msg format (see attached screenshot). We haven't found a good way to parse through these email messages, if anyone knows how to do that happy to learn!
For my second question, attaching the .txt file converted from .msg, looking to parse the data table out of the attached text file. See attached screenshot of the file uploaded in Alteryx as fixed width. I am looking for quick suggestions on how to easily parse through the data and I would appreciate the community's help. Thank you!
Hi All,
I have an update on this request, Actually there are 209 files tha tneed parsing and they do not have same structure but it's still intercompany errors. If anyone has any idea on parsing the combined data I can scrub and attach it here. Thanks!