Data with different column name

[#1]

Hi,

I am having requirement in which my QVD holds below columns.

Products

Customer Name

Purchase

Country Code

If tomorrow i have received the same file with different column name then my incremental script should not trigger and it will stop and send an alert for the same.

Column name Customer Name has been renamed with Customer_Name and Column name Country Code has been renamed with Country_Code.

Products

Customer_Name

Purchase

Country_Code

Is this condition handled in Qlikview.

Thanks,

Rohit

[#2]

Attaching the sample file for reference.

[micheledenardi]

Hi  Rohit,

with QVDs source isn't possible.

With other data soucre format you can select "None" on the labes and rename fields in the script.

[#4]

Hi Michele,

Just to clarify here that till data i have received the file with below columns

Products

Customer Name

Purchase

Country Code

Tomorrow if the any of the column name has been change then the data should not be appened with yesterday data, as the column header has been changed.

Products

Customer_Name

Purchase

Country_Code

Please advice on the same.

Thanks,

Rohit

[rwunderlich]

It sounds like you want to fail the reload, rather than tolerate the new column names?

-Rob