This is what is in my load script. The SLA6.1.Result and SLA6.1.Flag are pulled into the dashboard to display the results. I am pretty new to load scripting and am taking over this project from someone else.
Rahul, how do I add in your Where clause to this script. I am sorry, I am still learning this.
These are all good ideas, but still not ones that I think can help me here.
Perhaps some more context will help. This Load Statement is loading several other elements as well and what I am needing is just the first row from one of the many items. So to add WHERE RecNo()= 1; at the end of my Load Script would result in just the first record from each of the elements being loaded.
I need something like a Vlookup to the match to the specific row of the data.
I have made this work on the visualization side of things using this code: