Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Link multiple value column

Hi ,   I've a issue here. I am trying to create a relationship between two tables as shown in the picture. I am looking to have one table that filters Minimum requirement, actual skills , Descripti...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":

    Check whether this way will present all the data.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Amit,

 

Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

In your oringinal post,as the relationship between the 2 tables are many to many and you dont have a unique key,that's why you have duplicate values.

And in the last reply,as the direction in the relationship is single,so it may filter out some value,pls try to change the direction from single to both,see below:

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, v-kelly-msft amitchandak 

     

    I did change the filtering to both ways but my model still not pulling any values in the required value column.

     

    Please advise.

     

    Thanks,

     

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":

      Check whether this way will present all the data.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!