Track Compliance in Table Structure

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Track Compliance in Table Structure

jonathandienst — Thu, 17 Aug 2017 07:40:30 GMT

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.

topic Track Compliance in Table Structure in QlikView

Track Compliance in Table Structure

Re: Track Compliance in Table Structure