Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have one qvw application in which tables are already reloaded. But i need to create one more qvw and keep that before first qvw on server to check whether any compliance exist in new table structure. How do i track any changes in column name for new file?
Suppose I'm getting following excel after every two days and replacing first one. it can be multiple excel. if this new file has some changes in column name then i need to hault the script and save information of mismatch fields into text file. else it move the file on another location from where second qvw will fetch data. For moving data I'm running DOS command.
How do i check changes of columns for every new file ?
Data:
LOAD ReportingDate,
ID,
Code,
Country,
Level,
Emp_id,
Territory_id,
This shows how to get the structure of a source file:
TestFile:
First 1 LOAD *
FROM
Let vNum = NoOfFields('TestFile')'
For i = 1 To vNum
Let vName = FieldName(i, 'TestFile');
TRACE Field $(i) : $(vName);
Next
Drop Table TestFile;
Now adapt this code to your requirement.