Need Help in importing data in alteryx

[puja123p]

Hi. I have some data which I need to import in alteryx. Can anyone help in importing the same.

I have attached a sample file here.

I am using a Regex tool to insert a delimiter so that I can convert it using text to column tool, but i am not able to understand which expression i should use to get data of "Description" in one delimiter.

The output would be.

Thanks

[PhilipMannering]

Does this do what you need?

[cjaneczko]

Import it is Text.

Then select the following highlighted below. And it should work ok.

[cjaneczko]

Actually, My post wont work for your solution. The post above will. I just noticed is splits out too many columns based on the spaces.

[puja123p]

Hi Philip Mannering

I Have attached the output in the query. The workflow is not giving the desired result and also the amount is getting separated by comma when it should come in single column.

[PhilipMannering · Accepted solution]

Ah, I see. What about this?

[cjaneczko]

Is there any way to get your data source to output with Commas or Quotations around the data. You'd likely need to use regex to parse the data correctly, as its difficult to determine where the breaks are with the spaces.

[puja123p]

Thank you

[HomesickSurfer]

@puja123p , improt as fixed width text, without separators or separating lines, then make use the 'GetWord' formula expression to create your columns and applicable values.  Given that your data has 4 consistent numeric values at the end columns, I've used ReverseString on records 2+ and then ReverseString(GetWord([Field_1], 0)) for the total and repeat the process.