creating a visual with tables having many to many

[ashik1992]

Hi all 

I have doubt .Please help me .

I have two table one is projectgoal, and employeedetails. I want to create a report which showing employees who dont have project goal id and the corresponding timeline . 

table is very large and im unable to create relationship between the tables other than many to many .(more than 300 employees dont have project goal details )

Please help me to reslove

projectgoal 

employee	projectgoal id	timeline
ashik	12	q1
ashik	14	q2
rahul	15	q3
rahul	164	q4
sachin	454	q1
amal	77	q3
amal	56	q4

  and another table which having all employee details

employee	project date
ashik	1/1/2021
ashik	12/2/2021
siva	1/1/2021
rahul	2/2/2021
rahul	3/31/2021
sachin	1/11/2021
amal	11/3/2020
jai	1/1/2022
raj	1/1/2022

[jaipal]

@ashik1992  since you have no unique identifer in your tables, you only able to create Many - Many relationship.

In order to show only blanks ( no timeline & no id), go into the filters section and select only (Blank) .

please feel free to reply if it didn't work.

[jaipal]

hi @ashik1992  Can you share a bit more data that doesn't have project gole Id and Timeline. I just want to see how the data looks like, then it would be so easy

[ashik1992]

[jaipal]

@ashik1992 Can you take a screenhot of data? or create a sample data? to see how the data is looks like. or can you explain how the data looks like where there is no Project goal id and timeline

[ashik1992]

sample data is exactly same which i provided in description . 

That is from a Projectgoal table .

I have connected another table from sharepoint which have all the employee details and project .but some of the consultants have no project goa assigned . 

when there is no id,it showing blank

[Ashish_Mathur]

Hi,

Show the expected result very clearly.

[ashik1992]

expecting a result like this

[Ashish_Mathur]

Hi,

You may download my solution file from here.

Hope this helps.