2 Replies Latest reply on Nov 17, 2016 2:06 PM by Brianna J Pak

    Data converted to Null

    Brianna J Pak

      I am trying to create a sheet that compares two reports (Sheet A and Sheet B) from different workbooks. When I preview Sheet A data in the Data Area everything is correct, however when I drag Sheet A over to create a join with Sheet B, all of the Sheet A data is set to Null.  The data type is set as a string. I’ve done a comparison like this before with no trouble but can’t seem to figure out what is going wrong with this.

      Thank you,