Discussion board where members can get started with Qlik Sense.
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,
Can you describe your issue a bit more detailed?
Maybe with some screenshots or even better some sample records and your script?
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.
can you share your sample data?
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.