Forum Discussion

RohithGn's avatar
RohithGn
Icon for Helper I rankHelper I
9 years ago
Solved

Create a column by comparing two columns in a merged table

 Hi,

 

I have merged two tables table 1 & 2 to Table 1 and now I want to comapare two columns containing similar data and to display if both values are equal or not.

 

here is the sample Input and output - 

 

 

 

 

 

 

 

 

 

Could you please help me out on this.

 

Thanks,

Rohith

Need Help
Tutorial Requests
  • radpir's avatar
    radpir
    9 years ago

    hi,

     

    not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"

    = if [C2PC Status] = [MSX Status]  then "In Sync" else "Out of Sync"

     

    hope this helps,

    radpir

4 Replies

  • radpir's avatar
    radpir
    Icon for Resolver II rankResolver II
    9 years ago

    hi,

     

    not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"

    = if [C2PC Status] = [MSX Status]  then "In Sync" else "Out of Sync"

     

    hope this helps,

    radpir

    • RohithGn's avatar
      RohithGn
      Icon for Helper I rankHelper I
      9 years ago

      Just what i needed Thanks a ton Radpir!

       

      Regards,

      Rohith

    • smIqbal's avatar
      smIqbal
      New Member
      8 years ago

      Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.

    • smIqbal's avatar
      smIqbal
      New Member
      8 years ago

      Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.