In my SPL I use the associate command. However, I've noticed that when I use the command, any previous preliminary search results before the associate command are not available for use after the command.
Why is that and how can I save earlier search results until after the associate command for use?
The only method I can think of is to save the results prior to the associate command in a lookup table and then read them in later.
Yep. I tried that with in inputcsv and outputcsv. Something was wrong not sure what, still investigating. Trying to use tokens on the dashboard currently to hold the intermediate results, that may do what I need.
Still working that potential soln.
Yes, I believe so as well. Can you think of a way to get at my preliminary search results given that I may have a transformative command in the mix?
The only method I can think of is to save the results prior to the associate command in a lookup table and then read them in later.
Although not documented as such, I would consider associate to be a transforming command because of the behavior you describe. The command produces a specific set of output fields for each field processed. All other fields are discarded.