Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Problem with Join

Hi,

Anyone know why when a use a Left Join on my table that create a value from the secont table that not exist in the first table.

Code:

MONTAGEM:
LOAD
ID_INSTALACAO,
Segmento&NUM(ID_INSTALACAO) AS Cliente,
NUMERO_CADASTRO,
RAZAO_SOCIAL_CADASTRO,
LOGRADOURO_CADASTRO,
BAIRRO_CADASTRO,
CPF_CNPJ,
NUMERO,
BAIRRO,
UF,
MUNICIPIO,
COMPLEMENTO,
RAZAO_SOCIAL,
CNAE_FISCAL,
LOGRADOURO,
SITUACAO_CADASTRAL,
NMLG_TIPL_COD_ID,
NMLG_TITL_COD_ID,
CNPJ,
RamoAtividade,
EnderecoCompleto,
Desc_Cnae,
TIPO_CADASTRO,
vicinity,
name,
name_bkp,
Class_Google_PT,
TipoEstabelecimento,
RamoAtividade_Google,
Nota,
If(LEN(Teste)=0,'Erro',
If(LEN(CNAE_FISCAL)=0 AND LEN(Teste)<>14,'CPF',
'CNPJ'))AS TIPO Resident AUX_MONTAGEM;


drop table AUX_MONTAGEM;

Left Join Join(MONTAGEM)
LOAD
"Ponto-de-medição" AS Cliente
FROM [lib://Dados/Light P&D/cas_br_cuc/Planilha/Layout/Correcao_ID_Instalacao.xlsx]
(ooxml, embedded labels, table is Sheet0);

exit script;

Output:

 

Labels (1)
1 Reply
Highlighted
Partner
Partner

Re: Problem with Join

Can it be because you have written JOIN twice in this?

Left Join Join(MONTAGEM)