import text file , the description field break into 2 column

[Anonymous]

Hi All

My raw data :-

https://www.dropbox.com/s/ivvmktzj35c8eje/GL_TS_.TXT?dl=0

[Anonymous]

@Anonymous You can create a calculated column as below-

Column = CONCATENATE(Table[Column2],Table[Column3])

Appreciate your kudos!! Mark this post as accepted if this helps you.

[Anonymous]

Hi Sir

I copy your expression for new column , now the issue is the 2 column join together i need to add a space. can you advise me ?

[Anonymous]

@Anonymous - To add spaces, use this formula-

New Column  = Table[Column2] & " " & Table[Column3]

Appreciate your kudos!! Mark my post as accepted if this helps you.

[Anonymous]

Thank you it work fine now

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

The problem is that the text file is delimited by white space, and they look like space characters rather than TAB's.  But the data also contain spaces so it's confusing for PBI when it's importing.  How does it know where a column starts and ends?

Using a delimiter like a comma is much better to indicate where columns start/end.

To fix this, you could import the data using fixed width columns but that is likely to break if the width of the data changes.

So I'd recommend that you just import the file as it is, then merge the 2 columns that make up your description.

Phil