Forum Discussion
Analize historical data when ID changes
Not sure what the issue is without seeing a closer idea of what the data is. Wouldn't it just compile all your data regardless of what convention was used in the ID field? Or are you going to need to filter by something in the ID? If so, then, yes, you'll need to convert the old to new so they are consistent for filtering.
Not sure what the issue is without seeing a closer idea of what the data is. Wouldn't it just compile all your data regardless of what convention was used in the ID field? Or are you going to need to filter by something in the ID? If so, then, yes, you'll need to convert the old to new so they are consistent for filtering.
I now realized I did not express myself clearly, but yes, I need to filter something by the ID. I thought about that convertion (basically a new column where if ID = old, then grab the equivalent to the new one), but I was hoping for a solution using some sort of a related table.
Thanks for the help. If there's no further replies I will mark yours as the solution 🙂
