Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
We need to calculated an logic in edit script.Please find below.
Logic:
sum(ESIGN_COMPLETE_NEW)/sum(ToTAL_ORDERS_DAILY_NEW)
Script:
A:
LOAD A7AJCD,
A7AACD,
A7AIDT,
ESIGN_COMPLETE_NEW,
APA0TX
FROM
[F\QVD\Marketing\eSign\Daily_eSign.qvd]
(qvd);
B:
LOAD A7AJCD,
A7AACD,
A7AIDT,
TOTAL_ORDERS_DAILY_NEW,
APA0TX
FROM
[FQVD\Marketing\eSign\Daily_Total.qvd]
(qvd);
Thanks..
May be this?
A:
LOAD A7AJCD,
A7AACD,
A7AIDT,
ESIGN_COMPLETE_NEW,
APA0TX
FROM
[F\QVD\Marketing\eSign\Daily_eSign.qvd]
(qvd);
Concatenate(A)
B:
LOAD A7AJCD,
A7AACD,
A7AIDT,
TOTAL_ORDERS_DAILY_NEW,
APA0TX
FROM
[FQVD\Marketing\eSign\Daily_Total.qvd]
(qvd);
C:
LOAD A7AJCD,
A7AACD,
A7AIDT,
APA0TX, Sum(ESIGN_COMPLETE_NEW)/Sum(TOTAL_ORDERS_DAILY_NEW) AS NewTotals
Resident A
GROUP BY A7AJCD, A7AACD, A7AIDT, APA0TX;
DROP TABLE A;