There has to be a better way likely starting with some macro cleanup and parameterization. Note: I first had everything formatted and easy to read, but the macro had an error and I had to remove the line breaks (bug?) OR parentpartid_lvl98=tmp_partid OR parentpartid_lvl99=tmp_partid Im comfortable with left & inner join, however im trying to join two data sets that share the same field names but completely different values. I fear it might be so simple im overlooking it. | join type=left parentpartid_lvl98 overwrite=f | join type=left parentpartid_lvl99 overwrite=f ] | where parentpartid=tmp_partid OR parentpartid_lvl1=tmp_partid OR parentpartid_lvl2=tmp_partid OR parentpartid_lvl3=tmp_partid OR. Hi everyone, Ive tried to answer this myself but no luck. I decided this wouldn't recurse more than 99 times, so I wrote a quick shell script to generate a macro (parent_part_lookup): join partid | join type=left parentpartid_lvl1 overwrite=f | join type=left parentpartid_lvl2 overwrite=f | join type=left parentpartid_lvl3 overwrite=f. Any guidance or recommendation on creating a custom join or inputlookup. I need to be able to do this up to around 40 times (maybe more), but I'm happy to put a cap on it. Note: I put my initial part id into my search by doing this as part of (mysearch): "| eval tmp_partid=part02" I can then filter the results by using this statement: | where parentpartid=tmp_partid OR parentpartid_lvl1=tmp_partid OR parentpartid_lvl2=tmp_partid OR parentpartid_lvl3=tmp_partid OR parentpartid_lvl4=tmp_partid | join type=left parentpartid_lvl3 overwrite=f | join type=left parentpartid_lvl2 overwrite=f | join type=left parentpartid_lvl1 overwrite=f Here is my first hack attempt: (my search) | join type=left parentpartid overwrite=f Selfjoin does not appear to work as described (what little description exists). I need to join this data with this data: (mysearch) day, partid, partevent, count I have an lookup file: (parts.csv) partid, parentpartid
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |