topic Field Value transformation at load time in QlikView

Field Value transformation at load time

Anonymous — Wed, 03 Feb 2016 15:37:05 GMT

I am loading data from a data source into my QV document from MSSQL Server. One of the fields is called 'Payment Method'. One of the 'Payment Methods' or field value is 'Private'.

Can i change this value to 'Out-of-Pocket' at load time? If so, how can this be accomplished?

Regards.

Re: Field Value transformation at load time

sunny_talwar — Wed, 03 Feb 2016 15:38:51 GMT

May be like this:

If([Payment Methods] = 'Private', 'Out-of-Pocket', [Payment Methods]) as [Payment Methods]

Re: Field Value transformation at load time

Colin-Albert — Wed, 03 Feb 2016 15:49:21 GMT

Sunny's suggestion is fine if there is just one change, for multiple changes, create a mapping table and use Applymap.

By default if the mapping does not return a match, then the original value is used.

The advantage of the mapping table is that the list of changes can be easily managed in a spreadsheet or database without the need to change the load script.

Re: Field Value transformation at load time

Anonymous — Wed, 03 Feb 2016 16:04:04 GMT

Thanks Sunny

Re: Field Value transformation at load time

Anonymous — Wed, 03 Feb 2016 16:04:43 GMT

Thanks Colin for your valuable input