topic Re: Scripting in QlikView https://community.qlik.com/t5/QlikView/Scripting/m-p/802721#M665708 <HTML><HEAD></HEAD><BODY><P>Hi Niccolo, you wil have to use Resident and join or concatenate the tables bring from qvd </P><P></P><P>example</P><P></P><P>TABLE1:</P><P>load A,B,C from qvd1</P><P></P><P>TABLE2:</P><P>load A,X,Z from qvd2</P><P></P><P>newtable</P><P>load A,B,C </P><P>resident TABLE1;</P><P></P><P>left join</P><P></P><P>load A,X,Z</P><P>resident TABLE2;</P><P></P><P>good luck</P><P>Fernando</P></BODY></HTML> Tue, 30 Dec 2014 14:14:17 GMT fkeuroglian 2014-12-30T14:14:17Z Scripting https://community.qlik.com/t5/QlikView/Scripting/m-p/802720#M665707 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i am having some trouble doing the following: I have imported some qvd files that have automatically linked in outer join. What i need to do now is to create a table, that i will need to store as qvd, that bings togheter fields from the differen tables.</P><P></P><P>How do i do this? I don't understand which is my 'from statement'.</P><P></P><P>tx</P></BODY></HTML> Tue, 30 Dec 2014 14:05:48 GMT https://community.qlik.com/t5/QlikView/Scripting/m-p/802720#M665707 Anonymous 2014-12-30T14:05:48Z Re: Scripting https://community.qlik.com/t5/QlikView/Scripting/m-p/802721#M665708 <HTML><HEAD></HEAD><BODY><P>Hi Niccolo, you wil have to use Resident and join or concatenate the tables bring from qvd </P><P></P><P>example</P><P></P><P>TABLE1:</P><P>load A,B,C from qvd1</P><P></P><P>TABLE2:</P><P>load A,X,Z from qvd2</P><P></P><P>newtable</P><P>load A,B,C </P><P>resident TABLE1;</P><P></P><P>left join</P><P></P><P>load A,X,Z</P><P>resident TABLE2;</P><P></P><P>good luck</P><P>Fernando</P></BODY></HTML> Tue, 30 Dec 2014 14:14:17 GMT https://community.qlik.com/t5/QlikView/Scripting/m-p/802721#M665708 fkeuroglian 2014-12-30T14:14:17Z