Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

How can i Left Join() multiple tables?

Hi guys,

i have four tables: A, B and C.

I need to bring all the fields of table C in table B and all the fields of table B in table A.

What's the right expression to do this?

Thanks,

Mattia

Labels (2)
10 Replies
Creator II
Creator II

Hi,

here is attached the sample data file.

In the script, there are all the tables involved.

I need to join the tables in the following way:

from COM to TES

from TAR to DET and from DET to TES

from TAR to AMB2

from COM to AMB1 and from AMB1 to AMB2

So, i want this: all the fields of tables COM and TAR both in tables TES and AMB2.

I've tried also with applymap() but don't work. Other ideas are welcome!!!

Thanks,

Mattia