Forum Discussion
how to add trimming and lowering directly in a nestedjoin method ?
Hello, I have a step like this : = Table.NestedJoin(REQ1, {"EMail"}, REQ2, {"Email"}, "REQ2", JoinKind.Inner) I would like to optimize the result by trimming and lowering both columns EMail of R...
Hello, thank you but this adds a step. And this is what I wanted to avoid. Unless I can do like the following ?
= Table.NestedJoin(Table.TransformColumns( REQ1, { { "EMail", each Text.Trim( Text.Lowering(_) ) } } ), {"EMail"}, Table.TransformColumns( REQ1, { { "Email", each Text.Trim( Text.Lowering(_) ) } } ), {"Email"}, "REQ2", JoinKind.Inner)Ideally, I would like something like this :
= Table.NestedJoin(REQ1, Text.Trim(Text.Lower({"EMail"})), REQ2, Text.Trim(Text.Lower({"Email"}), "REQ2", JoinKind.Inner)Is is possible ?
KT_Bsmart2gethe
Impactful Individual
Impactful IndividualHi Anonymous ,
Table.NestedJoin(
Table.TransformColumns( REQ1, { { "EMail", each Text.Trim( Text.Lowering(_) ) } } ),
{"EMail"},
Table.TransformColumns( REQ2, { { "Email", each Text.Trim( Text.Lowering(_) ) } } ),
{"Email"},
"REQ2",
JoinKind.Inner
)