locked
data to analyze RRS feed

  • Question

  • I have three text data files with information about users, AD groups, and servers in this format:

    groupname,groupID,membercount
    user;groupID,groupID,groupID...
    server,groupID;groupID;groupID...

    I want to be able to:

    -click on a group and see all members

    -click on a server and see all groups

    -click on a user and see all group names

    Is it possible to put this into powerpivot given that the user and server rows are variable length?  I'm thinking the data would have to be formatted as

    user1;groupID1
    user1;groupID2
    user1;groupID3
    user2;groupID1
    etc

    and
    server1,groupID1
    server1,groupID2
    server1,groupID3
    server2,groupID1
    etc.

    thoughts?  TIA

    Friday, January 3, 2014 1:48 AM

Answers

  • Power Pivot doesn't perform those kinds of transfomations.  Power Query does that before the data hits the Power Pivot model.

    See

    Unpivot columns

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Elvis Long Friday, January 10, 2014 2:40 AM
    • Marked as answer by Elvis Long Monday, January 13, 2014 2:25 AM
    Friday, January 3, 2014 1:55 AM