How to convert .log file into Excel File

Help
1

Hello All,

I am trying to extract data from the JSON .log file into an excel file, I don’t have hardcoded columns names, Based on the JSON file automatically it needs to create column names.

I have attached the sample input and output file, Any help on this!

logfile.txt (817 Bytes)

Output format:

Time stamp Log level Message level logType ……… ………
13:33:19.8609 Info mySQLdb execution started Information Default ……… ………
13:45:41.4843 Error Aggravated Assault With A Deadly Weapon Information ……… ………
2

Hi @yogavalli

Did u tried using Generate datatable activitiy

Try using it and let me know if it works

Regards

Nived N :robot:

Happy Automation :relaxed: :relaxed:

3

Hello @NIVED_NAMBIAR,

I have tried but not working correctly.