I've got a question concerning a straight table:
I have a table like:
Name ParentName NameStatus.
John Charles Alive
Charles Andrew Dead
And I'd like to have a straight table like this:
Name NameStatut ParentName ParentStatus.
John Alive Charles Dead
I've tried set analysis like P(ParentName), lookup/peek doesn't exist in charts and only(TOTAL Status) but No Way!
Due to the amount of data, I need to keep one this information into one table in my datamodel.
Load * Inline [
Load Name as ParentName,NameStatus As ParentStatus Resident Temp;
I found this a very easy way to deal with this problem (still using resident):
Load Name as ParentName, NameStatus as ParentStatus resident Table;
This will load again your table, but now associating ParentStatus with ParentName. The association with the other table is automatically stablished.