![]() inputlookup Applications.csv fields AppNo, Application join typeinner AppNo inputlookup Functionalities.csv fields AppNo, FuncNo, Functionality This will pull all 4 rows. Yours would be like this: | inputlookup Applications. To make the logic easy to read, I want the first table to be the one whose data is higher up in hierarchy. Yours would be like this: | inputlookup Applications.csv | stats values(multifield) AS multifield values(Application) AS Application BY AppNo | strcat FuncNo "," Functionality multifield I still do not get exactly why the lookup is not adequate, but here is another way, without lookup in run-anywhere code: | makeresults inputlookup list250k rename ipcidr as ip eval convertiptostring (ip) lookup list65k ipcidr AS convertip OUTPUT ipcidr, list where isNotNull (ipcidr) rename ipcidr as foundin I am getting results. Am I doing something incorrectly, or does this really not work?įunctionalities.csv AppNo,FuncNo,Functionalityĭesired output AppNo, Application, FuncNo, Functionality Trying to read the lowest layer first is weird. The first 1 is much easier to read for anyone who comes after me, especially since I have 2 more input tables to join. Since join and type are dangerously similar to SQL, why does this not behave like SQL? I can only get all 30 rows when i switch the two lookup tables around, which shouldn't matter since it's an inner join. ![]() There are many more AppNo field values with a match in both tables, but only 4 are pulled. ![]() This will only ever pull 4 total rows, even if Functionalities.csv contains 30 matching AppNo field values. This will pull all 4 rows in Applications.csv, and only 4 rows in Functionalities.csv. To make the logic easy to read, I want the first table to be the one whose data is higher up in hierarchy. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |