Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on a material list. We have a field called MetalCode
Something similar to below
MetalCode
1001
1002
1003
1004
1005
Unfortunately this code everyone memorise and familiar. I want to replace this code to a String in report so that anyone can understand easily
.
i.e when User select 1001, the report should display MetalName instead of code. Like
Report for 1001 - Aluminium
The Matching Metal name as follows
1001 - Aluminium
1002 - Copper
1003 - Silver
1004 - Gold
1005 - Steel
Any suggestion ? Inputs please..
Thanks
Hi
Are you asking form mapping code ?
TABLE1:
MAPPING
LOAD * INLINE
[
MetalCode, Name
1001, Aluminium
1002, Copper
1003, Silver
1004, Gold
1005, Steel
];
TABLE2:
Load Price,
ApplyMap('TABLE1', MetalCode, 'Metalcodenotexists') as Newmetalname
inline
[
MetalCode, Price
1001, 1000
1002, 2550
1003, 45500
1006, 4778
]
;