Forum Discussion

MAS13's avatar
MAS13
Helper I
8 years ago
Solved

Bridge Table multiple dif naming conventions

So I am new to BI.  Some access exp.       Problem I have multiple datasheets with dif naming conventions sheet 1 - first_last_number sheet 2 - First Last sheet 3 - First Last (info) number   ...
  • MAS13's avatar
    MAS13
    8 years ago

    I actually think I figured it out.  I have 5 tables all with dif naming convention for user.  In the query part of bi, I extracted what I needed from that field, made a new column where the data was passed..  Then made the bridge table with the field user name that has a list of all employees in the company.  Built relationships between my 5 tables with the parsed user name and the bridge table..  This seems to work.. I have not tested fully yet.   If this sounds correct to you give me a thumbs up, if not please explain your way of solving this..  

     

    If you see that somehow down the line this would be an issue please let me know.. 

     

    Thank you in advance.

MAS13's avatar
MAS13
Helper I
8 years ago

I actually think I figured it out.  I have 5 tables all with dif naming convention for user.  In the query part of bi, I extracted what I needed from that field, made a new column where the data was passed..  Then made the bridge table with the field user name that has a list of all employees in the company.  Built relationships between my 5 tables with the parsed user name and the bridge table..  This seems to work.. I have not tested fully yet.   If this sounds correct to you give me a thumbs up, if not please explain your way of solving this..  

 

If you see that somehow down the line this would be an issue please let me know.. 

 

Thank you in advance.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi MAS13,

     

    From your posted image, it looks like you have established the relationships successfully. But without sample data, I was able to imagine your actual scenario. So, it's hard to give any comment about this solution.

     

    You said "I have 5 tables all with dif naming convention for user." How they are different? I want to see some detailed values of the name column in each table. And I also need to know how to map them depend on some specific rules.

     

    Regards,

    Yuliana Gu