Cannot set ROW_NUMBER() on Transformation Editor

SELECT ROW_NUMBER() OVER (ORDER BY A.state) as id , A.name, A.state, A.gender, A.birthyear,  A.occurences FROM 
            (EXEC file_source.getTextFiles('VA.TXT')) AS f,              
            TEXTTABLE(f.file COLUMNS state string, gender char, birthyear integer, name string, occurences integer) AS A;