Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Lookup in columns with in table loaded to qlikview

Hi,

With in a table, I have three columns which are loaded into qlikview.

First column name is 'ClaimNumber' (It contains numeric value which is unique for each row or line entry)

Second column name is 'Claimtype' (Only two types of Values are allowed i.e either 'MR' or 'PP' which means all line entries in the table pertains to either of these two categories).

Third column is 'Additional Number' (It is one of the value out of the values in the column with name 'ClaimNumber' but not same as 'ClaimNumber').

Ex:

Claimnumber: 20112222 and Claimtype is : 'PP' and Additional number is '345678'

Claimnumber: 345678 and Claimtype is :'MR' and Additional number is 'blank'.

Now I have to insert one more column after the third column with name 'FinalClaimType' and the requirement is,

in the fourth column against the claimnumber: 20112222 , I want the value as 'MR'  but not 'PP'.

Please help me...

Regards

Aditya

India

3 Replies
MVP & Luminary
MVP & Luminary

Re: Lookup in columns with in table loaded to qlikview

You can use a mapping table together with the applymap function in the script:

MapCN:

mapping load distinct Claimnumber, Claimtype

FROM mysource;

Data:

LOAD

     Claimnumber,

     Claimtype,

     [Additional number].

     applymap('MapCN',[Additional number]) as [fourth column]

FROM mysource;


talk is cheap, supply exceeds demand
Not applicable

Re: Lookup in columns with in table loaded to qlikview

Thank You. Mapping load and Applymap  function is really working........

MVP & Luminary
MVP & Luminary

Re: Lookup in columns with in table loaded to qlikview

Glad to help. Would you mind marking this discussion as answered if the solution solved the problem?


talk is cheap, supply exceeds demand