https://community.qlik.com/t5/Talend-Studio/type-of-the-expression-must-be-an-array-but-resolved-to-string/m-p/2262261#M42782 Hi <BR />Where do you input this expression? Can you please upload a screenshot of component settings? It will be helpful for us to find the problem. Thu, 18 Feb 2016 10:36:59 GMT Anonymous 2016-02-18T10:36:59Z https://community.qlik.com/t5/Talend-Studio/type-of-the-expression-must-be-an-array-but-resolved-to-string/m-p/2262260#M42781 Using tELTHiveMap component I am trying to join between 2 tables.&nbsp; The join condition is a bit complex: <BR /> <BR />table1.col1 =&nbsp;trim(substring(regexp_replace(upper(table2.col2), ""," ")), 0, instr(trim(regexp_replace(upper(table2.col2), ""," "),' '))) <BR /> <BR />It is basically get the first word in uppercase from table2.col2. <BR />The TOS gives the error "type of the expression must be an array but it resolved to string" <BR />How do I resolve this? <BR />The generated Select statement runs through Hive command line successfully.&nbsp; Sat, 16 Nov 2024 10:48:25 GMT https://community.qlik.com/t5/Talend-Studio/type-of-the-expression-must-be-an-array-but-resolved-to-string/m-p/2262260#M42781 Anonymous 2024-11-16T10:48:25Z https://community.qlik.com/t5/Talend-Studio/type-of-the-expression-must-be-an-array-but-resolved-to-string/m-p/2262261#M42782 Hi <BR />Where do you input this expression? Can you please upload a screenshot of component settings? It will be helpful for us to find the problem. Thu, 18 Feb 2016 10:36:59 GMT https://community.qlik.com/t5/Talend-Studio/type-of-the-expression-must-be-an-array-but-resolved-to-string/m-p/2262261#M42782 Anonymous 2016-02-18T10:36:59Z