Forum Discussion

usuario112's avatar
usuario112
Frequent Visitor
2 years ago
Solved

big database

Hi, i have like 50 tables in a database, my main idea is extracting specific data to make calculations from it but the problem is the data is spread in like 6 tables totally apart from each other, a...
Need Help
  • selimovd's avatar
    selimovd
    2 years ago

    Hey usuario112 ,

     

    do you have access to create views in the database? If yes, then this would be my preferred approach.

    Otherwise I would load the data in a dataflow and then you can do the operations there.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi
    Follow me: twitter.com/DenSelimovic

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hey usuario112 ,

 

do you have access to create views in the database? If yes, then this would be my preferred approach.

Otherwise I would load the data in a dataflow and then you can do the operations there.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

usuario112's avatar
usuario112
Frequent Visitor
2 years ago

selimovd i'll check that, thanks a lot