Hi All, I found the solution. Upon importing of the file, only 1 column of data is visible when using '|' as the delimiter. This text file was originally an exported file from SAP.
To display the entire expanded data set with its original columns, you need to open the Advanced Editor where you'll see the display code as below (I've blanked out the file address).
Within this code, look for 'Column1' (outlined in Red).
Here, I simply changed the 1 to 21 as you can see, then the entire table expanded from one column to 21 columns, displaying all the original data from the source file.