SAC: combining data in dataset, model from files.

[Vikinos]

Hello,

new to SAC, i use trial version. I have problem when loading csv. files to the model. It's a classical example of database tables, where you have multiple tables joined by keys. 

What i want to achieve:
my example data consist basically from two master data tables airporst.csv, airlines.csv, which describe specific details for each airline or airport,  and one transaction data (also csv) flights.csv. I want to joint these three tables into one in modeller.
Flights.csv have a int foreign key airport_id and airlines_id that can be joined to airport.csv and airlines.csv tables.
It's very easy to join these three tables into one result table with sql, pandas, powerBi but impossible task in SAC. Why ? How do you combine data in modeler ? 

I saw 3 years old yt tutorial video  which shows button for merging data. However, in new SAC version this button is missing. Is this problem with trial version or general SAC problem ? 

Thank you all for aswers,

Victor

[ihar_stankevich · Accepted solution]

Hi @Vikinos, 

This feature is available in classic (old) model. 

In new model it will be available (according to roadmap) in Q2 2025

[Vikinos · Accepted solution]

Thank you, got it. Maybe for others to quickly find old model => create_model.

[Yogeshwar_M]

Hi @Vikinos,

Import Your CSV Files
You need to import each of your CSV files (airports, airlines, and flights) into SAC separately as individual data sources.

Go to the Modeler in SAC.
Choose Create a New Model.
Import your CSV files one by one (you will need to create separate data sources for each)

Create one dimension Namely Data source and Add Member as Airport Airline Flight 

While uploading the data Mapping properly as per data source 

For example if you are import airport CSV you need to Mapp default Data source as Airport. 

Kindly upvote if you find it helpful!

Thanks.