topic Re: Adding a column in Script in QlikView

Adding a column in Script

Emma — Wed, 24 Apr 2019 08:52:57 GMT

Hi all,

My query is pretty straight forward, I have the following table as input and would like to add a colum in the script while loading data in Qlikview.

(Picture of data below) Please note that the input data cannot be changed at the source.

INPUT DATA:

My goal is to add a column in the script that will rewrite the same description IF the Count =0 for every unique ID.

The data should look like this:

The nulls in New_Column can be replaced by something else like a number as long as it's different from the Description value.

Thank you.

Re: Adding a column in Script

arpitkharkia — Wed, 24 Apr 2019 08:58:50 GMT

Add the following column

if(count=0,Description) as New_column

Re: Adding a column in Script

Emma — Wed, 24 Apr 2019 09:13:15 GMT

Hi Arpitkharkia

Thanks for the reply. Apologies I forgot to mention a critical detail. Some of the data looks like the following:

Your approach will make it look like this:

Instead of the desired result, which is this:

If there is a method to replace all the "Count" that have 0 with the first "Description" that has a count=0, that would solve the issue.

Many thanks

Re: Adding a column in Script

arpitkharkia — Wed, 24 Apr 2019 10:13:30 GMT

im not sure how all of the data looks like and how new data will look in the future, but what i can think of now is to create a mapping file with three columns, description, count and new column.

You manually add the details of the new column accordingly and left join it to the main table.

I hope this makes sense Emma, else please let us know.

Regards,

Arpit