ppines's latest activity

  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    No syntax errors are reported by Poor SQL (a useful online tool you might use) for the supplied SQL, however I made some adjustments -...
  • P
    ppines replied to the thread SQL Hangs.
    When I make this amendment I receive the following message: "Syntax error in FROM Clause."
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    Try this - I do not think you need to use UNSW_Maths table - appears to be trying to retrieve course code twice. The focus is to id the...
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    Yes - all the inner joins are unnecessary if the desired Student Profile records required always contain valid FK references. Any...
  • P
    ppines replied to the thread SQL Hangs.
    I have used Excel to clean the data (using 'advanced filter' and 'remove duplicates'), redesigned the database based on the start schema...
    • 1738911210402.png
    • 1738911243973.png
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    From the picture there are 6 duplicates of each of the 2 records shown, however the data set is much wider than shown. Are the columns...
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    Step 1: Identify and remove duplicates: in what sense are they duplicates? As this is an extract of data / combined data from multiple...
  • P
    ppines replied to the thread SQL Hangs.
    Thank you! I will use this to create the new database.
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    A star schema might look like below, however I do not have the subject matter expertise to be sure about the placement of data in the...
  • P
    ppines replied to the thread SQL Hangs.
    See attached example, same line item repeated for the Student in the original Excel file.
    • Duplication Example .png
  • P
    ppines replied to the thread SQL Hangs.
    I was asked to use MS Access by the Math faculty to clean the data and create the query. I don't know SASS or SPCC. UNSW_Maths table...
  • P
    ppines reacted to GaP42's post in the thread SQL Hangs with Like Like.
    Form what is being described at #14, the data is only for reporting so the OLTP normalised model is not applicable. This is essentially...
  • P
    ppines reacted to LarryE's post in the thread SQL Hangs with Like Like.
    You don't know which records are actual duplicates and which are not because your data is in spreadsheet format and not normalized into...
  • P
    ppines replied to the thread SQL Hangs.
    The original Excel file was 277MB - 72 columns 912902 rows - and is riddled with duplicate records. I originally uploaded this file into...
  • P
    ppines replied to the thread SQL Hangs.
    There are 913,300 records. I want to find all the duplicates and delete them first, then complete the TRANSFORM. If I remove the...
Show older items
Back
Top Bottom