Analyze .log files

[qais1975]

Dear All,

I have a month long .log files generated from SAS 9.4 studio. I downloaded these .log files and would like to use Alteryx to analyze them.

on type of analysis which I would like to do, for example, compare them to track similarities and differences as well as time stamp tracking.

will you be able to direct me to a good way to do that in Alteryx? 

thank you so much!

qais 

[Yoshiro_Fujimori]

Hi @qais1975 ,

Could you attach a sample .log file?

[qais1975]

Dear @Yoshiro_Fujimori ,

The log generated from SAS log about system performance and it is private data that I can not shared.

best regards

Qais

[Yoshiro_Fujimori]

Hi @qais1975 , understood. C'est la vie...

My suggestion is to get SAS document which describe the metadata of log file.

Then you can consider how to parse each component.

Depending on the format, you may want to choose from the selection of parsing tools.

DateTime

RegEx

Text to Columns 

XML Parse 

JSON Parse 

I'm afraid this is all I can say. Good luck.