Replace name in table

[#1]

HI.

I'm new in Qlick:)

I've got two tables on one sheet. In these tables i've got column Main product group. In first table i'd like to print right names from Main product group. But in second table i'd like to replace sone names. FOr example:

1st table - main product group are:

DGU

VSG

ESG

2nd table main product group:

DGU - I want to print Fasade

ESG - I want to print Interior ESG

VSG - I want to print Interior VSG

Please help me.

Magda

[stephencredmond]

Hi,

You will need to load a table to match your code with description like this:

Load * Inline [
ProductGroup,ProductGroupName
DGU,Fasade
VSG,Interior VSG
ESG,Exterior ESG
]

You could also load it as a mapping table and map it into your key table, but this will work as well.

Regards,

Stephen