i have a date excel file which as dates in it and i loaded it
now i want set variable to store the above date
i want to load the file
but instead of file name 12jan2018.xsl i wanna use variable set on step 2, how can i achive that,it used happen dynamically
Perhaps something like below?
LOAD * Inline [
LET Variable = Peek('Date',0,'Sample');
(ooxml, embedded labels, table is '$(Variable)');
Instead third step your needed is this
in step 1 i have loaded a Date file which contains Date field
and i want to set a variable(say the varible is 'v') to store the Date field
later i have one more file to load wich is loaded from [../xyz_2jan2018] but i want to load like [../xyz_$(v)]
May be Loops using Peek() can deserve, But still not sure what your question ending up?
I have not seen any difference from him and mine