SQL Transformation
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