Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey any one has good example for apply map. as im first time using this feture
thx in advance.
Hey
Pls can any one explain me where the use of apply map?
HiPlease go through example
-------------------------------------------------------------map1:mapping load * inline [
ID, Textvalue
1, one
2, two
3, three ] ;
ApplyMap ( 'map1', 1, 'xxx' ) It will return 'one'
ApplyMap ( 'map1', 2 ) It will return 'two'
ApplyMap ( 'map1', 4 ) It will return 4
ApplyMap ( 'map1', 5, 'No result' ) It will returns No result---------------------------------------------------------------
Regards--
Nayan
Hi
Suppose you have two tables say Cutomer master and Sales, Now Customer Master table contain CustID, CustName
and Sales conatin CustID, Amt etc. Now if you want to find Customer Name wise sales then you can Use Applymap to find Customer name by usinf CutomerId
Hi Nayan
thx for reply
ApplyMap ( 'map1', 1, 'xxx' ) where i has to write in etl script or Experssion?
thx nayan once again.pls let me know where i can write this Apply map Script?
you can write in application Script
Hi Im getting error.pls find beloow script any mistake in beloow script
LOAD
UniqueID
,
ID
FROM
ABC.txt
(
)
where
;
map1:
mapping
[
ApplyMap
( 'map1', 1, 'xxx' ) ;
thx once agin.
Hi there,
I have just blogged on the many uses and the required syntax for the ApplyMap Statement:
http://bit.ly/kQcAZ5
Regards,
Steve
i have a question....
in apply map statement it would return one, two ,or three as they are mentioned in inline above
like one for 1
two for 2
three for 3
n would return no result for 5 as its nt present in line while using applay map this is clear
thn why it would result 4 for 4???????
applymap('map1',4) returns 4 // how?????????
