Compare two log files

[Wangwn]

Any Alteryx tools for comparing two log files and idenfying the changes? There may be some addition, removal an revision between the before and after log files therefore the lines are off. Thank you in advance for your comments - Winnie

[KaneG · Accepted solution]

Hi @Wangwn,

I use a Join tool for this. You need to prepare your log files in to the correct fields first though. In the attached example I have brought in 2 Alteryx Log files, and parsed to get the ToolId and Message, then used a Join tool to compare and find the differences. 

Hopefully that gets you further down the path. Naturally, you will need to customise and expand the module to deal with the things that will always be different like temp directories and times.

[Wangwn]

Kane, thank you for sharing your knowledge! The log file that I am dealing with doesn't have the sort of ToolID identifier, so I have to join the message/content only, is that correct?

[KaneG]

Yes, normally in a log file you would have a couple of independent identifiers along the row... but if not, then you can just join on everything except the time...

Kane

[Wangwn]

Thank you Kane!