-
1. Re: Data mapping
Jim DehnerJun 9, 2018 2:50 PM (in response to Yeok Song Ng)
1 of 1 people found this helpfulHi
I feel your pain -
This is very similar to dealing with changes in product lines where one product replaces another but the client was to see the history as if it is a single product
One way to do it is with a cross reference table that you could join (not blend) with the data - think of the Current active ID as your unique identifier and another dimension as "Old ID" The current ID is unique (the parent) but can have many "Old Id's including the current ID) in that way you can form a hierarchy from current ID to all the id's tied to it
Then join them and use your current id as the unique identifier in the Viz
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.