Left Join generated rows without data

[livio218526]

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

[swuehl]

Can you describe your issue a bit more detailed?

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

[livio218526]

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.

[Anonymous]

can you share your sample data?

[Mark_Little]

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