AnsweredAssumed Answered

Creating new HCI documents based on extracted fields

Question asked by Eckhard Roeser Employee on May 10, 2017
Latest reply on Jun 6, 2017 by Eckhard Roeser



I'm looking for a solution how I can reorganize extracted field values into new entities? Something similar as I would extract a CSV or log file into their lines and create a new document for each of these lines. But the content of these lines come from before extracted field values. For instance:


I do have the following multi value fields extracted from other documents:

field1=["A" | "B" | "C" | ...]

field2=["1" | "2" | "3" | ...]

field3=["x" | "y" | "z" | ...]


And I want to reorganize them (or create new documents for indexing) like this:

newfield1=["A" | "1" | "x"]

newfield2=["B" | "2" | "y"]

newfield3=["C" | "3" | "z"]



and so on depending on how many objects field1, field2 and field3 have. The number of objects are the same in these 3 fields. But vary from case to case. Then in the end I would like to index newfieldx fields to search in there.


I have looked to the help for Parsing and indexing CSV and log files. But this seems to be a different story, although it looks pretty similar. Not sure if I can use this for my case?


Does somebody have an idea how to approach this?


Thanks and rgds,