Let me try to explain what I’m trying to do:
- I have several set of data linked to a date (for a given date, it can have to up to 50 different data), as an example:
date1 date 2 ...
class 1
sub class 2
sub class 3
data 1 12.5 25.3
sub class 4
data 2 .02 .04
...
the subclass can be up to 5 levels and the data can be up to 50, which means for each data, I’ll have 1 date and 1 number associate to it, so there will be a lot of “repeated” date for each number, what’s the best practice to solve this? I was thinking in using table, then I’ll have a lot of duplicate date, if I setup a variable, each number will have to reference to the date variable, which I guess won’t solve my problem (which is to avoid repetition).
ps:
- I’m new to TW, not sure if I set it up correctly, I think I’ve added Shiraz dynamic table, but can’t figure out how to use it, can someone please take a look at my file and check if I missed something?
- sorry, my English is not that good, so if there’s something not clear, please let me know and I’ll try to explain it better.