Join , Concatenate or what else?

[amars]

Hi all,

I have been working in Qlikview for more than a year, but couldn't understand this, hope to know it from u. Suppose I have a Table like this

Table1:

Fields Field1, Field2, Field3

Now I do Select Field1, Field2, Field3 from Table1 Where Some condition 1

Now I load some different table Table2 which contain's name for Field2 like

TAble2:

Fields Field2, Field2Name. with a query like

Left Join (Table1) Select Field2, Field2Name from Table2 ;

Now suppose I have some rows of data to be added to the Table1 with some different Where Clause like

Join (Table1)

Select Field1, Field2, Field3 from Table1 Where Some condition 2

I didn't understand what should I be using in the above statement, join or something else. I know join will work. But I am using join for appending a single field as well as to add multiple rows of data with same format. So what should I be using ideally.

Sorry if I am too lengthy in asking the question. And Thanks in advance.

With Regards

Amar

[#2]

Hi Amar

As I understand you try to extend Table1 with a partial load and condition 2?

If your condition 2 is not producing duplicates with condition 1 I would do a CONCATENATE but you need to join with table 2 again to get the Field2Name populated for your additional entries.

Regards

Juerg