Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fipsarqlik
Contributor II
Contributor II

Changing the values in the existing tables/loads

Date Load Script

 

Is it possible and supported by Qlik to change the values in the existing tables/loads ?

If possible how to change value of any field on any required row in a Load?

Labels (4)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Yes, like already hinted in my example:

if(Field1 = 'x', 'y', Field1) as Field1,
applymap('Map', Key, Field2) as Field2

 but if you do it you couldn't apply the wildcard * for the fields anymore because it would lead to duplicate fields which aren't allowed.

- Marcus

View solution in original post

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You need to load the table and within the load you could adjust the values maybe with:

...
if(Field = 'x', 'y', Field) as Field,
applymap('Map', Key, 'Default') as FieldXYZ
...

- Marcus

fipsarqlik
Contributor II
Contributor II
Author

Is there any way to change the values of the fields on the same field names. without creating new fields

marcus_sommer
MVP & Luminary
MVP & Luminary

Yes, like already hinted in my example:

if(Field1 = 'x', 'y', Field1) as Field1,
applymap('Map', Key, Field2) as Field2

 but if you do it you couldn't apply the wildcard * for the fields anymore because it would lead to duplicate fields which aren't allowed.

- Marcus