Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Mergin Queries - Bug?

Hi all,   I have a really annoying problem:   I'm trying to merge two queries and can't get the columns to match... to illustrate the problem I have reduced my tables to only two columns each and...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Could there be some extra space after some text..?
    For example "MRG " in one table ..."MRG" in another

    You can use custom Column to check this

    Text.Length([Col 1])

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Could there be some extra space after some text..?
For example "MRG " in one table ..."MRG" in another

You can use custom Column to check this

Text.Length([Col 1])

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Zubair_Muhammad That was correct. I trimmed and cleaned the column and it worked fine.

 

Thanks!