Why the relation inspreadsheet will be logically limited?
Can you give me example that shows the limitations of setting up relations in spreadsheet?
1 answers ( 0 marked as helpful)
Hi Vikrant!
Thanks for reaching out.
In fact, you will be exploring such differences throughout the entire course. Excel per sé doesn't provide you with tools to quickly retrieve certain types of relations between the data stored in different tables as SQL does. Yet it all starts from this lecture: https://learn.365datascience.com/courses/sql/relationships/
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Kind regards,
Martin