Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

niccolo24
Not applicable

Scripting

Hi

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.

How do i do this? I don't understand which is my 'from statement'.

tx

1 Reply
fkeuroglian
Not applicable

Re: Scripting

Hi Niccolo, you wil have to use Resident and join or concatenate the tables bring from qvd

example

TABLE1:

load A,B,C from qvd1

TABLE2:

load A,X,Z from qvd2

newtable

load A,B,C

resident TABLE1;

left join

load A,X,Z

resident TABLE2;

good luck

Fernando