Importation TXT file to QLIK

[cmutombo]

Hi Community

I need to import a TXT file on Qlik for analysis. the issue is :  my TXT file have two columns with different names  

1. 'STATUS' 

2. 'WORK STATUS' (with different kind of respective data) 

'STATUS' have 1,6 and 'WORKSTATUS' have 1,4,5      

In process of importation QLIK consider those two columns in same name 'STATUS' and then have an error message (not Unique).

I have try to rename one of them on loading 'STATUS' AS 'STATUS_2' now the issue is QLIK give data of one of column for both of them.  STATUS' = 1,6 and 'STATUS_2' = 1,6  also...........I lose column that give me : 1,4,5

Please Help

[rubenmarin1]

Hi, can you post the script you are using to read the txt? and the first row of the txt (column names) so we can see the structure of the file.