Using SQL in MS Access - Wanting to remove row duplication and create columns with me
I'm working with a MS Access 2016 Database that was used by a client using a software based e-commerce application that was very old and dated.
I've created an SQL statement to abstract the data I need for creation of a CSV for Shopify
The SQL gets what I want, but creates many duplications of content due to the way the data is held in the Database,
There's a table in the Database called Variable that holds variable definitions created by the end user when using the e-commerce software. Such as:- if a Product was to have multiple images associated with it they could create ExtraImage1, ExtraImage2 which then be available for all products
There's a second table called UserDefinedVariables that holds the values of the Variables that are associated to products.
My issue is the above SQL gives the output of:
The repetition of content for sString1 to 4 is expected as these are product dropdown content. However, in my Database I want to output the values of variables ExtraImage1 to 4 without it grouping them as it does. Is there a way I could state in SQL when there's an occurrence of ExtraImage1 found in sName create a column header called ExtraImage1 and place its associated value from UserDefinedProperties.sValue directly under it in the new column?
Last edited by gazbutcher16; February 14th, 2018 at 04:21 PM.