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

    2011年12月14日 下午 06: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
    2011年12月27日 下午 09:45

所有回覆

  • Hi Dan,

    I am working on this issue. I will update with you soon.

    Regards,
    Jerry

    2011年12月16日 上午 09:08
    版主
  •  

    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
    2011年12月27日 下午 09:45