Clean and Trim

Hello flinch 

 

I've tried some experiments with your data, but no way that I was able to no join them. Here the code if somebody want to try.

And so you are saying that exactly this 2 rows in your final table didn't join?

let
    Table1 = 


    let
        Source = #table
            (
                type table [Column1 = number, Column2 = text, Column3 = text, Column4 = text, Column5 = text, Column6 = text, Column7 = text, Column8 = text],
                {
                    {"1105","BP01","BALL POINT PEN (EACH)","C","STATIONERY LOCAL","","0","No"}
                }
            ),
        Transform = Table.TransformColumns
        (
            Source,
            {
                {
                    "Column2",
                    each _,
                    type number
                }
            }
        )
    in
	    Transform,
        

Table2 =
    let
        Source = #table
        (
            type table [Column1 = datetime, Column2 = datetime],
            {
                {"BP01","1.095.944.348"}
            }
        )
    in
        Source,


Join= Table.NestedJoin
(
    Table1,
    "Column2",
    Table2,
    "Column1",
    "tbl2"
)
in
    Join

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy