Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a variable vTagNames defined as Alpha,Beta,Gamma all three of which happen to the columns of a table I am about to load. Now what I want to do is fetch the Timestamp field and only fields defined in the variable i.e Alpha,Beta,Gamma in this case from my table and not x,y and z or any other fields which might come in future.
I am thinking about using for loop and iterating over all the fields and comparing them with the ones stored in my variable.
Is this correct? If yes, How to implement? If not, what is the right approach?
Below attached is an excel sheet containing the table...
Thanks.
LOAD
Timestamp,
$(vTagNames)
FROM ....
-Rob