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 an...
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

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