topic Left join a column with a table in QlikView

Left join a column with a table

Mon, 14 Jun 2010 02:37:40 GMT

Hi All,

i've a requirement and hopefully someone here can give me a suggestion.

I'm trying to left join adding a column from a qvd file to a another fact table in qvd format too.

eg: calander_week left join Sales fact table

Can anyone suggest how should i accomplish this in scripting?

Thanks in advance.

Left join a column with a table

Mon, 14 Jun 2010 05:30:11 GMT

In script, you can explicity make a left join.

From the QlikView help file:

QVTable:

select * from table1;

left join select * from table2;

From the example above, QVTable will contain every record from table1 and those records will have fields from table2 where they match (using QlikView same-name join logic).

Hope this was helpful,

James