Level 1 Source to Target Mapping Part 7

Options
SusieSchmidley
SusieSchmidley Member, ALL USERS, Partner Posts: 1 New Contributor

In the Importing Data Modules Activities for Employee Details, I'm having issues matching the employee names with the source.  It does not recognize the employee name in the 2nd tab ( "#E2 Employees") and therefore does not match the names.  See Screen Shots. 

Comments

  • jpleboeuf
    jpleboeuf Member, ALL USERS, Community Member, Certified Model Builder Posts: 3 Occasional Contributor

    @filip.sypniewski "as well as my codes are 001 instead of 1. Though, these of course do not make any difference."

     

    This did make a difference for me.  I had to go change the formatting for the Code column in the source file to Text and then copy/fill 001, 002, etc. to get the auto-match to work.  Maybe I'm not understanding something, and I eventually got there, but maybe others will have the same issue so I thought I'd mention it.

  • jpleboeuf
    jpleboeuf Member, ALL USERS, Community Member, Certified Model Builder Posts: 3 Occasional Contributor
    I'm struggling to understand what I'm supposed to do about the date formatting as well (other than just change it in the source data). In the videos, there is a Time tab that you can access if Time is a dimension, but here it is not.
  • jpleboeuf
    jpleboeuf Member, ALL USERS, Community Member, Certified Model Builder Posts: 3 Occasional Contributor
    Thank you so much!!!