Text format not able to extract properly

[Amy123]

Hi Team,

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

THanks

[Jonny]

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

[Amy123]

@Jonny 

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

[Jonny]

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!