LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mspeakman

Hello, I'm very new to LAE and have had very little training. What I'd like to do is pretty simple just not sure of how to accomplish the task in LAE. I have a set of data that uses phone number as a unique identifier. I have a directory of files I'd like to scan through to pull back additional fields using the phone number as the linking field. How do I accomplish this?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You say you have a directory of files.. what format are the files?

You could use a directory list node and feed the list of filenames into an ExcelReader, or a DelimitedFile node or a CSVFile node .. depending upon the format of the files.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sabyasachi

File1:-
Phnumber,name
111111,aaa
222222,qqqq

File2:-
Phnumber,name
111112,aaaq
222223,qqqqa

Please past the below code in BRE:-

node:Directory_List
bretype:core::Directory List
editor:sortkey=564eb1f97c612681
output:@40fd2c747c2b1c0a/=
prop:DirectoryName=E:\DIR\
prop:Pattern=*.*
editor:XY=170,110
end:Directory_List

node:CSV_File
bretype:core::CSV File
editor:sortkey=564eb24f3e9b7470
input:564eb24f57f06ca7/=Directory_List.40fd2c747c2b1c0a
output:@41e6c6cd11e613c6/=
prop:FilenameExpr=<<EOX
FileName
EOX
editor:XY=270,110
end:CSV_File

node:Static_Data
bretype:core::Static Data
editor:sortkey=564eb26907aa7aa6
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
PHNUMBERLOOKINGFOR
222223
EOX
editor:XY=320,190
end:Static_Data

node:Join
bretype:core::Join
editor:sortkey=564eb28e24233d53
input:@40fd2c745b6d7704/=CSV_File.41e6c6cd11e613c6
input:@40fd2c74504921cd/=Static_Data.40fe6c55598828e5
output:@40fd2c7430f76546/=
prop:JoinType=lir
prop:LeftInputKey=<<EOX
Phnumber
EOX
prop:RightInputKey=<<EOX
PHNUMBERLOOKINGFOR
EOX
prop:Script=<<EOX
emit 1:Phnumber,1:name
where join.match
EOX
prop:VerifyInputsSorted=false
editor:XY=380,110
end:Join

Hope this will solve your purpose.

Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mspeakman

Thank you for the response. I will give this a try. Regarding the earlier questions, the format of the files in the directory are .csv files. The file I was to match against is an excel file.