Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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