Map fields together

[#1]

I have tables LinkDate and DATA_NEW tables. I would like to link the reporting_date of LinkDate to DATE of DATA_NEW. However, I do NOT want to change the DATE of DATA_NEW to reporting_date because this would break my dashboard in many places. How can I do this linkage? thank you

[marcus_sommer]

You could just double your DATE field and rename it to create the connection, something like:

DATA_NEW:

load *, DATE as reporting_date from Source;

- Marcus