Table Structure - How to handle loop

[#1]

Dear All,

I have a file with below table structure:

Some of the table has weekly base detail and some of them has daily base detail. So I have connected all of the over MAster Calendar. But I also want to connect my tables over Hat, Hat1, Hat2 and Hat3 (Green circles on the snaphot). How can I succeed it?

Thanks for your support.

Best regards,

[erichshiino]

This answer may apply depending on your data, ok?

Can you concatenate all the tables except for the calendar. Then you will use only one hat field.

You can transform calendarweek, calendarmonth and calendardates just on dates and then create a master calendar. For weeks and months, just transform it on the first day of the week or month.

After this, you need to handle the different timeframes on the interface (weekly analysis for weekly data and so on).

We can discuss you model a bit more if you prefer.