none
Friendly name horror

    คำถาม

  • Hi there,

    So I had a huge excel sheet with about 400 columns of various questions (eg.  What kind of industry are you in, etc), with discretized responses (1 - Tech, 2-Health Care etc).

    I brought it into SQL, but you can't have columns with long winded sentences, so I replaced the column headings with Q1, Q2 etc.

    Now I am trying to data mine this, so I created a Data Source View and spent three days coming up with a friendly name for each of these 400 questions.

    Imagine my horror when I created a Mining Structure and a model and it reverted to using the Q1, Q2 column names instead of the Friendly ones that show up in the DSV.

    Please, PLEASE tell me there is an easy way to force these friendly names to be used in a Structure and all subsequent models.  The alternative would seem to be to spend another three days doing the exact same re-naming at the structure level rather than the DSV.


    Dan

    14 ธันวาคม 2554 18:38

คำตอบ

  •  

    Hi Dan,

     

    In the Data Source view, are you using sql tables/views (from SQL)?

    You can replace them with "Named Query" and select the column as different name/alias.

    For example, you can select Q1 column as [WhatnewaliasnameIlike] with below TSQL syntax:

     

    select ..... Q1 as [WhatnewaliasnameIlike] ..

    from ....

     

    Once the alias for the column is in the DSV, you can then create structure and models based on it.

     

    NOTE: If you only want to just create alias for particular mining model column, you can follow below

    http://msdn.microsoft.com/en-us/library/bb895187.aspx

     

    Hope this helps.

     

    Thanks.

     


    Meer Al - MSFT
    • ทำเครื่องหมายเป็นคำตอบโดย Jerry NeeModerator 5 มกราคม 2555 10:09
    27 ธันวาคม 2554 21:45

ตอบทั้งหมด