How to modify my script to avoid the $Syn key on currency ?

[paulyeo11]

Hi All

Now My Table look very neat like below :-

After i add below script :-

WhatIfDimension:
LOAD * INLINE [
What If Dimension Rate, Column89
S$,Rate
Org,Rate_
];

WhatIfDimension:
LOAD * INLINE [
SOURCE,Currency, Rate
TDS,SGD, 1
ADL,SGD, 1
PMC,SGD, 1
TID,RP, 10000

];

WhatIfDimension:
LOAD * INLINE [
SOURCE,Currency, Rate_
TDS,SGD, 1
ADL,SGD, 1
PMC,SGD, 1
TID,RP, 1

];

Currencies:
LOAD * INLINE [
SOURCE: CurrencyFormat:
TDS: S$ #,##0 K;(SG $#,##0 K)
ADL: S$ #,##0 K;(SG $#,##0 K)
PMC: S$ #,##0 K;(SG $#,##0 K)
TID: S$ #,##0 K;(RP $#,##0 K)
] (delimiter is ':');

I am aware the $Syn key is harmless. 

As you can see that now table model start to getting messy. 

I have decided not to edit my above script for currency  , so that my table can look neat. I am still able to have display in other country currency.

Can some one share with me what i should do ? 

Paul Yeo 

[paulyeo11]

Enclosed my QVW.

[MarkWillems · Accepted solution]

There is no need for two tables here, they are the same keys , so put them in a single table and this will remove the synthetic key on currency

Replace:

WhatIfDimension:
LOAD * INLINE [
SOURCE,Currency, Rate
TDS,SGD, 1
ADL,SGD, 1
PMC,SGD, 1
TID,RP, 10000

];

WhatIfDimension:
LOAD * INLINE [
SOURCE,Currency, Rate_
TDS,SGD, 1
ADL,SGD, 1
PMC,SGD, 1
TID,RP, 1];

With:

WhatIfDimension:
LOAD * INLINE [
SOURCE,Currency, Rate, Rate_
TDS,SGD, 1,1
ADL,SGD, 1,1
PMC,SGD, 1,1
TID,RP, 10000,1

];

[paulyeo11]

Hi Mark

Thank you very much for your sharing.

Now my table is more neat now.

Paul Yeo

[paulyeo11]

Hi Sir

sorry I not create a new post . 

i also feel like to remove currency field.

it is okay that my table display both Org and S$ will display S$ Amount . ( if you refer to my QVW sales TAB )

But my issue is how to make my table title value label display the currency sign ?

hope you can advise me.

Paul

[MarkWillems]

No worries, Right click on the table and go to properties.  Select the "Number" tab and select Money.  You can directly alter the format pattern to change the currency symbol being used.