Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Track Compliance in Table Structure

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,

          

1 Reply
jonathandienst
Partner
Partner

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein