For our data warehouse we have a lot of reference tables. It would be nice if I could place them in the main module on 1 sheet and then share these tables with the other modules in the project so that I do not have to repeat the import in each module.
Is that possible ?
More generally: it would also be nice if we could pass multiple datasets to a module when we call it. If I am not mistaken, we can send only 1 dataset to a module using the input action? The dataset that is sent is the dataset in the table where the call to another module action is positioned.
In some cases, it could be use full to send multiple datasets to another module.
It would be nice if I could place them in the main module on 1 sheet and then share these tables with the other modules in the project so that I do not have to repeat the import in each module.
Even if such a mechanism existed, you would still have to use some kind of action to receive one from multiple input datasets. I can't see how it would simplify a workflow compared with importing datasets. In both cases there should be an action that produces the desired dataset.
Or some “+” button in the call another module action? When pressing on “+” then a drop down appears in which we can select the table that we want to pass. In the module we would have different input actions.
The difference would be fewer import from database actions I guess.