How to use IN operator in matillion

Matillion ETL
1

I have two data sources D1 and D2 and i want to filter data from D1 using condition :- SELECT * FROM D1 where D1.customer_key in (select customer_key from D2)

2

Hi @shivamsachan303​

The query syntax that you wrote seems to be working.

You just have to use a SQL query component that is taking data from both tables (D1-D2) and you should be able to do it in Matillion.

3

@shivamsachan303​ instead of relying on a subquery, you can achieve the same thing using an inner join. You can use the Join component to achieve the same.

Hope this helps.

4

Thanks for the reply, Is there any way to do it without using SQL component as to use SQL component there should be a source table but in my case I do not have source table here data is coming from matillion join component

5

You can use any component in matillion as a source table in case its connecting with your SQL query component.

You have to use $T{JOIN COMPONENT NAME} as your table name in query.

6

Thanks, it worked for me.

7

Glad it helped 😀

8

I have one more query is there any way to perform group by operation using calculator component.

9

You can perform it using aggregate component or SQL Query.