Hi,
For some reason my screen capture did not post here. Adding some additional pictures of trace + method without SQL and with (without works).
Some more background: I am creating a hit pick based on xlsx. file import. The issue im trying to work around arises when I want to use the following SQL command:
“SELECT * FROM [fileplaceholder.xlsx] WHERE [Volume] > 10”
To allow for imported variable instead of just one file I found this post which I tried to adapt to my protocol: SQL Command from variable worklist - #6 by DanHartman_Hamilton
I followed this as precisely as I could trying to use concat, replace and getfilename to work around that I have variable file names (opened from a dialogue).
Original protocol:
I am still learning so most likely im missing something obvious.