Originally posted by: SystemAdmin

Hi.,
Till now we are doing a dblookup in type tree- component rule. now the criteria changed and need to do a lookup from a text file (which has a unique name all the time) which would be in map directory. the current rule is

EntityTypeQual'r Element:$ = "1" &
PRESENT(DBLOOKUP("Select F2 from tblHHINDB where F1 ='"+ TEXT(LEFT(IDCd Element:IDCd Element MComposite:$,3))+ "'" , "-MDQ 270Elig.mdq -DBNAME HHINDB")) &
WHEN(PRESENT(IDCd Element MComposite:$),
MEMBER(IDCdQuar Element:IDCd Element MComposite:$,
{"AA","CC"}))

first we need to read the file then do a look up. any inputs please???
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: LaurentB

I'm afraid this is not feasible, since a LOOKUP needs to be done against a series, and there is no series until you're inside a map.

An equivament would be to add one input card to your map, and use the MEMBER or LOOKUP functions to fetch this serie and check the rule...
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: TarunB

Is the filename completely unique or is there any part of it that is identifiable? Or can you alter the creation method of the file so that it contains some identifiable component? Then you could read it in via an input card as a trigger file, and process as normal.

Alternatively is it possible to work out the filename from within your map? Or can the name be sent to the map in any other way (say in another input file that has a fixed name). If so then you can use GET FILE in an output card and use the data there.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

luckily i was able to do thru type tree....the file name would be unique all the time and would be available in map directory.
the logic i used is...
PRESENT(FIND(GET("FILE","HHINBX.txt"),LEFT(IDCd Element:IDCd Element MComposite:$,3)))

thanks guys.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender