Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
Need Urgent help : we have 18 Qvds of same name the only difference is month and year. like xyz_20160101 and xyz_20170601 etc. i have to load last 12 qvds.(aug-16 to Jul-17)
date format : xyz_yyyymmdd.
1. i want to write a loop condition to load all these last 12 qvds.
2. also i want to extract the new qvds from db with changed strcture(just new columns are added) now i have to concatinate the both old and new extracted qvds and save them on the same path from where we took old qvds.(overwritting the old qvds).
// Old Qvd
LOAD Date,
[Customer ID],
Sal
FROM
(qvd);
// New Qvd with additional columns
LOAD Date,
[Customer ID],
Sal,
Rating,
Cycle
FROM
Please help me as this has to done very urgently. Thanks
YOu probably can use a for loop:
or a For Each ... Next Loop:
may be
Table:
'' as Dummy;
Concatenate
LOAD *
FROM
(qvd);
Drop Field Dummy;