Join several tables

[ecabanas]

Hi, I extract data from different tables and the result for 

How to do that:

Thanks

Counter_754:

LOAD 
	SalesId,
	COUNT(ItemId) AS 'Cerveza_754',
    sum(Import_Brut) as 'Importe_754'
    RESIDENT Salesline
    WHERE Catlevel2='754' and wildmatch(SalesId,'PV0*')
    GROUP BY SalesId;
Counter_758:

    LOAD 
	SalesId,
	COUNT(ItemId) AS 'Cerveza_758',
    sum(Import_Brut) as 'Importe_758'
    RESIDENT Salesline
    WHERE Catlevel2='758' and wildmatch(SalesId,'PV0*')
    GROUP BY SalesId;

[dplr-rn]

Its not clear what the issue is. What are you trying to achieve?
but on face value it seems wrong doing it in script. the count and sum you mentioned can be done on front end using Set Analysis

[ecabanas]

I want to join all tables in only One. I don't want to do it in set analisys

Thank's

[dplr-rn]

joining is just. 

table1:

load ....

from xyz;

left join (Table1)

load ...

from abc;

the kind of join depends you your requirement. check this

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...