I have a piece of SQL Script and after every piece I have identifier for new columns (orders) after that I can use this identifier to work with another parts (where orders.maxdate2=1) What is the best practice make this identifier in SQL Component?

Matillion ETL
1

I have a piece of SQL Script and after every piece I have identifier for new columns (orders)

after that I can use this identifier to work with another parts (where orders.maxdate2=1)

What is the best practice make this identifier in SQL Component in Transformation job?

0694G00000OuoaZQAR_0D54G00008tPLEVSA4
0694G00000OuoaZQAR_0D54G00008tPLEVSA41772×918 206 KB

2

Hi there @dmytriy.zhelznyak​ and thanks for your patience.

If you're still looking for an answer to this, the WHERE clause could be implemented as a Filter. This documentation here might help you further. Let us know if that helps at all.

Many thanks,

Claire