LEFT JOIN with Deffierent field name

[#1]

I want to join two tables with differnt field name but having varying number of rows. Can you please help me how can we join the two table.

I am attaching an excel for example.

With Regards,

Vikas

[#2]

HI so I want to join two table (TABLE 1 and TABLE 2) with differnt field name (one as NAME and another ar ADMIN) but FIELD ADMIN has more rows then NAME and dont want to miss out any row.

I hope I made it little clear.

Regards,

Vikas

[#3]

Hi Mayil,

I am still not getting the answer..any other sugession.

Regards,

Vikas

[MayilVahanan]

Hi,

     Try this,

User:
Load * inline
[
NAME,JOB
ANDREW,IT MANGER
JOHN,Director
SAM,Analyst
];

Join(User)
LOAD * Inline
[
ADMIN,JOB
ANDREW,IT MANGER
JOHN,Director
SAM,Analyst
VICTOR,Analyst
CATHY,Analyst
PETER,Analyst
];

or instead of join(User) use Concatenate(User)

or Qlikview automatically join all the field based on Job as key without use join or concatenate.. because in both table Job is the common field..

Hope it helps

[#5]

Hi Myail,

My table has couple thousand data...I cannot put everyone's name and job title while loading.

With Regards,

Vikas

[MayilVahanan]

Hi,

     Check your data, there is common field in both table. Like job in your example, if so qlikview automatically merged both table with that Common Field..So no need to join..

For example i used inline table. you can use like this,

    User:

     Load Name, Job from filename1.fileextension ;

     Admin:

     Load Admin,Job from filename2.fileextension;

So its automaticall merge all data based on job field..

Want to concatenate means,

User:

Load Name,Job from filename1.fileExtension;

Concatenate(User)

Load Admin,Job from filename2.fileExtension;

Hope it helps

[#7]

Hi Mayil,

Actually there is not common data in both the table...I just gave an example as JOB but suppose one has JOB adn other has title then, I am sure there is no common field in botht the table but have to join both NAME and ADMIN field.

Regards,

Vikas

[MayilVahanan]

Hi,

Use like this,

Step1:

Admin:

     Load RowNo() as key, Admin, Title from filename1.fileextension;

User:

     Load RowNo() as Key, Name, Job from filename2.fileextension;

Step2:

Admin:

     Load RowNo() as key, Admin, Title from filename1.fileextension;

join(Admin)

     Load RowNo() as Key, Name, Job from filename2.fileextension;

note: instead of join you can also use "Concatenate(Admin)"

Step3:

Admin:

     Load Admin, Title from filename1.fileextension;

User:

     Load  Name, Job as Title from filename2.fileextension;

From these steps, any one of the step, i think your requirement achieve..

Hope it helps