Text format not able to extract properly

Question

Hi Team,

Can someone help me to get the text format in Alteryx properly.

THanks

Test.txt

Jonny · Answer

Hi @Amy123

The "Period Period Part Account in one column" is the column with your "original data", you don't need it. the other columns should be right.

you can ignore the 1st column using the select tool.

open the Select Tool configuration and deselect the 1st column:

and the last column:

can you try now and let me know if it works? see attached

Thanks!

Text format not able to extract properly_input_Jonny2.yxmd

Amy123 · Answer

@Jonny

I am getting Period Period Part Account in one column and that's not correct

Jonny · Answer

Hi @Amy123 ,

I built the attached workflow:

- used flaf file -  mapping one column.

- skip 1st two lines

- dynamic rename to get column names

- text to columns with tab delimiter to get your columns right.

- auto filed to adjust data types

It seems to have worked.

have a look and let me know if it works for you?

cheers!

BR/Jonny

Text format not able to extract properly_input_Jonny.yxmd