How to rename and reuse files from the same location in one workflow?

[KKWang]

Hello, 

We hope to make a complete workflow based on SQL, but the method I can think of at present can only run the step of' create table previous _ results' separately.
Is there any way to merge them together?  

The SQL likes:

CREATE TABLE tbl_Previous_Results

AS SELECT * FROM tbl_Current_Results

SELECT column_a, column_b, column_c

INTO tbI_Current_Results

FROM [database]

SELECT tbl_Current_Results.a,   tbl_Current_Results.b,   tbl_Previous_Results.c

INTO tb_c

FROM tbI_Current_Results

LEFT JOIN tbl_Previous_Results

ON tbl_Current_Results.b = tbl_Previous_Results.b

The workflow now:

 

 

Really appreciate!

[WesCannon · Accepted solution]

Hi @KKWang 

I would suggest using the Block Until Done Tool to first write the previous file ensure that the file has been written prior to trying to re-open it later in the workflow.

Thanks,

Wes

[KKWang]

Thanks @WesCannon , the answer is really useful.