topic Mapping Table - Change Values in QlikView

Mapping Table - Change Values

Anonymous — Fri, 15 Aug 2014 10:35:28 GMT

Hi at all,

i need help please:

i have two tables:

1. Table DATA:

- S-Number (Key)

- Price

2. Table MAPPING:

- Mapping.S-Number (Key)

- Mapping.New-S-Number

I want to replace the S-Number (Table DATA) with the Mapping.New-S-Number (Mapping.New-S-Number) with the same Key (S-Number and Mapping-S-Number). Finnaly Group By Price

Atachement:

- Screenshot

- .QVW

THANK YOU VERY MUCH!

Re: Mapping Table - Change Values

bbmmouha — Fri, 15 Aug 2014 10:50:31 GMT

tri to "select as" when u import data

Re: Mapping Table - Change Values

simondachstr — Fri, 15 Aug 2014 10:51:59 GMT

Voila - lucky for you I was having a 15' loading process running in the background.

Re: Mapping Table - Change Values

Anonymous — Fri, 15 Aug 2014 13:08:53 GMT

THANK YOU!!! YOU MADE MY DAY