Need Help in importing data in alteryx

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

Sample.txt

Workflow.yxmd

Workflow

Accepted answers

philipmannering

Ah, I see. What about this?

Workflow.yxmd

All comments

philipmannering

Does this do what you need?

Workflow.yxmd

cjaneczko

Import it is Text.

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

Text Import.yxmd

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

Ah, I see. What about this?

Workflow.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703