BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jcheema
Calcite | Level 5

I have three questions:

1. Can a Table Loader Transformation have more than one input?

     Can we connect it to two data sources or do we always have to connect the two data sources to a SQL Join transformation and output of that is         connected to the Loader.

2. How do we delete rows in a target table?

3. How can I get max/min values of some columns along with class/by variables ?

Regards,

Jagtar Cheema

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20
  1. No. If you want to load data from more than one source in the same step, use SQL Join or Append transformations as input to a table Loader. If you want to load data from multiple sources independently you can add more Table Loaders to the job, or creating multiple jobs.
  2. If you need to delete all rows in the target table, it is an option in the tabel laoder transform. If you want to delete rows in target based on the input, there are some options in the update/insert scenario you can use. If you want to delete rows using other scenarios, you might want to write your own "delete from" code in a User Written Code, or as a pre step in the table loader transform.
  3. There are several ways, and the best way depends on what you are going to to with the result. You can user the Extract or SQL Join transforms to create min/max analysis with GROUP BY.

Br

Linus

Data never sleeps

View solution in original post

2 REPLIES 2
LinusH
Tourmaline | Level 20
  1. No. If you want to load data from more than one source in the same step, use SQL Join or Append transformations as input to a table Loader. If you want to load data from multiple sources independently you can add more Table Loaders to the job, or creating multiple jobs.
  2. If you need to delete all rows in the target table, it is an option in the tabel laoder transform. If you want to delete rows in target based on the input, there are some options in the update/insert scenario you can use. If you want to delete rows using other scenarios, you might want to write your own "delete from" code in a User Written Code, or as a pre step in the table loader transform.
  3. There are several ways, and the best way depends on what you are going to to with the result. You can user the Extract or SQL Join transforms to create min/max analysis with GROUP BY.

Br

Linus

Data never sleeps
jcheema
Calcite | Level 5

Thanks.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1873 views
  • 0 likes
  • 2 in conversation