Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

Left Join generated rows without data

Hy Everyone,

I use the Left Join between 3 table, but the files resulted by this operation have a lot of rows without data and I don't understand why.

Please, help me.

Thanks in advantage,

Livio

4 Replies
MVP
MVP

Re: Left Join generated rows without data

Can you describe your issue a bit more detailed?

Maybe with some screenshots or even better some sample records and your script?

livio218526
Contributor

Re: Left Join generated rows without data

I have 3 files in excel:

- HFM left join with MAP MARKET (Key is Market Code);

- HFM left join with MAP PRODUCT (Key is HFM Code);



but during the join I have a lot of black rows.

sahadevpatil
New Contributor III

Re: Left Join generated rows without data

can you share your sample data?

mark6505
Valued Contributor III

Re: Left Join generated rows without data

Hi,

Some more information would be helpful, Script, example data or screenshots of what is happening

Going off what you have said i would guess that the are rows in the excel document that isn't actually blank, but have a space or something in.

Try adding a where clause to the load

Where LEN(TRIM([Market Code])) > 0;

and so on for the other fields and see what you get.

Mark

Community Browser