Hi all, I need to replace this behavior that I've already in MS Access: MS Access table (input) |----> query (based on previous table) |----> query (based on previous query) |----> query (based on previous query) |---->MS Access table (output) Somebody could suggest me how to replace this in Talent Open Studio (v. 3.0.3) ??? Thanks in advance
Does anybody has a suggestion? It's a quite important issue for me, thanks
Hello nLenoci
I think it is impossible to finish it with the sql statement as you said, we can only iterate the rows in previous query, so you must output the result from previous query to a table or tempopary file first.
Best regards
Hi nLenoci, technically you are doing only one query (with different views as input). So you could do the same in Talend if you can define the views in your database. If this is not possible you could try to implement the logic in you job. But I think doing it in the database (if possible) will be the fastest way. Bye Volker
