none
data to analyze

    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 03, 2014 1:48 AM

Answers