Forum Discussion
Managing Relationships
parry2k I'm not sure how it's going to work since pieces of it is connected to our SQL DB. But here is the link:
https://drive.google.com/file/d/1hHKpiElazNqmloG6buCydspj6iUKS7mA/view?usp=sharing
The datasets I'm working with are 'Cservice' and 'EMS Survey' and the fields from each that I would like to connect on (if possible) are 'co' from Cservice and 'New Id' from EMS Survey.
Hi,
That link takes me to a page which says that i need permission.
parry2k Ashish_Mathur I figured that's what it would do. I am not sure how to share this data with you guys because I'm pretty sure I can't hand out company credentials.
Anonymous first and foremost we are unable to download the file as Ashish_Mathur .
Easiest way is to pull sample data from SQL in excel sheet and send that over, it will be much easier that way. You can always send private message with the link if you are not comfortable sharing on the forun. Make sure remove any sensitive information.
parry2k Ashish_Mathur After more trial and error I believe I've figured out the solution to my own problem. I basically had to create another unique ID by merging 2 different columns. After that I was able to join the 2 tables I've been wanting to join and have been able to create the necessary formulas. Thank you both for standing by and being very responsive to my issues.
