SQL Transformation

December 18, 2015

Report Abuse
this very simple example shows how SQL transformation works
2 datasets are entered manually with the following values: c1,c2,c3 "a",1,2.3 "b",2,3.4 "c",3,4.5 and c1,c4 "x",1 "y",2 "a",3 "b",4 "c",5 They are combined by the SQL Transformation module which takes up to 3 tables. Here we used only the first two: t1 and t2. ![enter image description here][1] The SQL statement is select t1.c1,c2,c4 from t1 inner join t2 on t1.c1=t2.c1 order by c3 desc and the result is c1 c2 c3 c 3 5 b 2 4 a 1 3 [1]: http://blog.3-4.fr/2015/12/18a/img/sql_transformation.png