Read in txt file

I have a text file(.txt) with about 1,600 lines, the format is as follows

slmonname
23288GDIA-Alteryx - Prod Controller server123abc Memory
slstatusmessage
36% virtual memory used, 46474MB virtual memory free, 45.3296 pagessec/
sltime
08:01:02
sldate
0511/2020/

This is repeated about 200 times, my question is , what methods can i use to get this out to a table format, my headings would be
slmonname, slstatusmessage,sltime,sldate

Any creative ideas ?

Datasets

Reporting

Regex

Tips and Tricks

Common Use Cases

Best Practices

Accepted answers

Jonathan-Sherman

You could pivot your data once brought in:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200511 - ParseTextFile.yxzp

All comments

Jonathan-Sherman

You could pivot your data once brought in:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200511 - ParseTextFile.yxzp

I'm trying to look over your yxzp however its failing to open, i fear it may be bcause it was created with a newer version?

I have designer 2018.3

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335