Hi, I've got a query about writing what should be a relatively straight forward bit of script.
What I have is two tabs on the go, each with a seperate table in it saved to seperate qvd files. In one table I want to make a comparison of dates like so:
date (field name) - date (field name 2) as [Date difference]
However, this second field name is within the second tab, how do I reference it so that when I run the script it only pulls in the data for that one field and not the entire table again?
Could you attach script. I assume that you want to calculate the date difference for each line, so there must be some link between the two tables but I cannot visualise your data with the info so far.
hi, I don't know how to really attach the script let me know if this isnt what you meant:
Left
Join
(AP_detail)
LOAD
RMPYID
as [Payment ID]
,
RMDCTM
as [Payment Doc]
,
// RMDOCM as [Doc No],
// RMPYE,
// RMGLBA,
RMDMTJ as [Payment Date]
,
Date
(MakeDate(1900+left(text(RMDMTJ),len(RMDMTJ)-3))+right(text(RMDMTJ),3)-1) as [Date Of Payment]
,
Date
(RMDMTJ) - Date (RPDDJ) as [Actual Payment Days];
// RMVDGJ,
// RMICU,
// RMICUT,
// RMDICJ,
// RMPAAP,
// RMCRCD,
// RMCRRM,
// RMAM,
// RMVLDT,
// RMPYIN,
// RMISTP,
// RMCBNK,
// RMBKTR,
// RMTORG,
// RMUSER,
// RMPID,
// RMUPMJ,
// RMUPMT,
// RMJOBN;
SQL
SELECT
*
FROM
TRDTA.F0413;
Store
AP_detail into data
/AP_detail.qvd;
In this script I need to make the statement understand that RPDDJ is infact in another table called AP_Ledger, in database called TRDTA.F0411 however I need to make sure that only the RPDDJ is loaded from the other table, otherwise the load time will be far too long,
