Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two inline table I want to use applymap function in Data table , so its possible to use it.
CountryNamesMap:
MAPPING LOAD * INLINE [
ShortName, LongName
ES, Spain
US, United States
];
Data:
LOAD * INLINE [
CountryCode
ES
UK
US,
];
Thanks,
Vijay
Find the attachment
where is the attachment?
Got it.
Thanks
if you got your answer make the post as correct or helpful and close this thread,so other get right solution
MAP:
MAPPING LOAD * INLINE [
ShortName, LongName
ES, Spain
US, United States
];
Data:
LOAD * INLINE [
CountryCode
ES
UK
US,
];
Data1:
load
CountryCode
,applymap('MAP',CountryCode ) as FullName
resident Data;
Drop table Data;
Here is a thread for you