Read in txt file

[rvandel3]

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 ?

[Jonathan-Sherman · Accepted solution]

Hi @rvandel3,

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

[rvandel3]

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

[rvandel3]

nvm I got it, ill have a look , thank you

[Jonathan-Sherman]

Hi @rvandel3,

Try this version (saved as 2018.1)

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan