Power Query Question

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Greetings!I have a data like belowIn column A, we have different Organizations, and in B, I want like if A contains "L3 SW" or "CP Integration", then put L3 SW, but in Conditional column in Else IF, only one criteria can be choosen as below:-Can you please share how and which format shall be used so that "or" can be used in same condition as below? "," doesn't help seemsThanks in Advance,Br,Anupam

sergeibaklan · Answer

That's in formula bar or in Advanced editor. Start conditional column in interface, next modify the code in editor, something like
...
    AddColumn = Table.AddColumn( PrevStep, "Custom",
        each
           if Text.Contains([Reporter Team], "VRF") then "VRF" else
           if Text.Contains([Reporter Team], "L3 SW") or Text.Contains([Reporter Team], "CP Integration") then "L3 SW" else
           if Text.Contains([Reporter Team], "CNS") then "CNS" else
           "nothing", type text),
    NextStep = ...

sergeibaklan · Answer

In UI you may add one more condition which returns the same value
...
Else if &lt;Reporter team&gt; &lt;contains&gt; &lt;L3 SW&gt; &lt;Then&gt; &lt;L3 SW&gt;
Else if &lt;Reporter team&gt; &lt;contains&gt; &lt;CP Integration&gt; &lt;Then&gt; &lt;L3 SW&gt;
...
&nbsp;

anupambit1797 · Answer

Thanks SergeiBaklan​ can you please confirm if this "or" option is not available via GUI? and only Advance editor is the option with PQ.Br,Anupam

Forum Discussion

Power Query Question

3 Replies

Resources