Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Re: conditional join

thank you for your reply however I am looking for a way to do condition on inner join when merging the two datasets.

4 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Anonymous 

     

    After using the filter option, you can see the File1 that contains the columns which have only values.

    You can see the result as below as there is only one common column.

     

    I hope this information helps.

     

    Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      thanks for your message however your test is not as per my requirement in the original thread.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi Anonymous 

         

        Apologies for the inconvenience from my end.

        Could you please elaborate on the issue you are encountering by sharing additional details, such as screenshots, would be very helpful in understanding the problem and guide you in better way.

         

        Thank you.