Extract Particular Data From TXT File To Excel file

[Uma_Shankar0201]

Hi All,

I have to extract data from .txt file to excel file. I need to extract particular data from text file. I have attached both the input file as well as the required excel format. Could you please help me on this.

Thank You !

[AbhilashR]

Hi @Uma_Shankar0201, you should be able to bring in the .txt file as is inside Alteryx using a regular input tool, after which you can use a combination of text-to-column and sample tools to transform the data within Alteryx.

When brining in the .txt file, make sure to bring it is as csv format, and set the delimiter to \0. This ensure alteryx brings the raw data into the canvas as-is.

Hope this helps.

[Uma_Shankar0201]

Thank you Abhilash for helping me. But my main requirement is to fetch date, Yr/QTR and remaining in tabular format same as I attached with query.  May I have complete solution to get this format.