I have to add three tables to my user written transformation. But add input/add input is not highlighting.
Can you please anybody help me on this. Thanks in advance.
Hi,
If I remember properly in 3.4 version you cannot add input/output in the transformation,but you can add three user written code transformation for three tables and then append or do a SQL join what ever you want.But for sure in 4.2 version of DI this can done very easily by just doing drag and drop.
eg: table1----> user written code
Table2----->User written code
Table3----->User written code
or in one user written code write you code in properties--->process---->userwritten---->edit and all the code you want to write.
If I am wrong please correct me.
Thanks,
Shiva
If I recall right, the last screen in the Generated Transform wizard, you can specify the minimum and the maximum no of inputs and outputs to the transformation. This should also be available at the properties window of the transformation object (in the inventory/Custom tree).
http://support.sas.com/onlinedoc/913/docMainpage.jsp?_topic=etlug.hlp/a003162717.htm
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.