Create a new data

[Farzaneh_]

Hello, 

I integrate my file to Qlik Sense. Now, I want to create a new data by the data I already integrate. 

In my Excel ('feuil1'), I have several colon, the one I want to use is X. I want to create data Y by the value of X :

If X is AA or BB, my Y will be AAA. If X is CC or DD, my Y will be BBB. If X is NULL, my Y will be CCC and in other case, my YY will be DDD. 

I think of using code in data load editor. 

How should I write my code ? Help please. 😞 

[vikasmahajan]

Hi,

You can create a mapping in excel  & make use of apply map in Qlik script to achieve this requirement.

Vikas