topic Data with different column name in QlikView

Data with different column name

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data with different column name

Tue, 23 May 2017 13:33:24 GMT

Attaching the sample file for reference.

Re: Data with different column name

micheledenardi — Tue, 23 May 2017 14:44:49 GMT

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.

Re: Data with different column name

Tue, 23 May 2017 17:07:10 GMT

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

Re: Data with different column name

rwunderlich — Tue, 23 May 2017 17:12:24 GMT

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

-Rob