qlik

[Dolly123]

T1

company code , company name

1000 , syb

2000, qsd

1000, opl

i want show in fact table company code and company name

[Mark_Little]

Hi
Can you provide some more details on the use case? As currently it looks like a simple load from statement

[MayilVahanan]

Hi

You can use Mapping concept to bring company name based on company code in fact table. Something like below

MapCompany:

Mapping Load companycode , companyname from urtablename;

Load *, ApplyMap('MapCompany', Companycode, 'NA') from urfacttable;