I have a SQL view that is getting exported to a text file that gets imported into the autofill keyword set. The file currently holds these values: M00000001,03/31/1915,09/01/1947,09/01/1947,08/28/2015,06/02/2007. I need another autofill keyword set, but instead of creating a new SQL view, could I add to that view and then export a new text file for the second autofill? The new file would show: M00000001,123456789,03/31/1915,09/01/1947,09/01/1947,08/28/2015,06/02/2007,John,Doe,Smith. I don't think that OnBase would be able to figure out the placement of the info I need. Like set one doesn't need the extra data that is in spot 2, 8, 9, and 10. And then the second import wouldn't need 3, 4, 5,6,7. I think I'm making this too hard and should just create another view but was trying to keep things simple and just have one view. What are your thoughts and has anyone done something similar? Thank you!
