Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Custom SQL Query as an Iterator

Hi,

For some reasons we don not want to use Table iterator.
But we want to use a column values of an SQL query which would act as an Iterator.
For example -

Select key from Table order by key asc;
I want to use use this Key column values and use it to iterate through the process.

Is this possible ?

3 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Nachiket,

Assuming the SQL is run against your target platform, you may create a view and then reference the view in the table iterator.

Does that help?

Best
Kalyan


Nachiket Mehendale —

Hi Kalyan,

Thanks.
Let me test it and get back to you.

Regards
Nachiket


Nachiket Mehendale —

Hi Kalyan,


Thanks. It is working. I am closing this ticket.

Post Your Community Answer

To add an answer please login