Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Have got an issue....
I have loaded the following data:
...
left Join
load
Fulldate,
Mid(Fulldate,1,3) as Month
FROM
$(vPath_Reference_Data)DimTime.qvd
(qvd);
Then I wanted to create a list box of the Months, but that was not possible since the field month is not there to be choosen. But the Fulldate it is there. Can anyone explain me whats going on?
Thank you very much.
Iuri,
Please post a sample data.
Marc.
Can you post your complete script.
Did you reload the script after you added above Load statement
Try Month(Fulldate) instead - My guess is that it is a date and that is held numerically.
Hope it helps
Rupert
Hi Rupert,
Thanks for your answer, but still dont work, I think because the date is in Spanish.
The format of the date is "December 2014"
But wanted a list box with Dec, thats is why I used "Mid". In a TextBox if I use Upper function appears the DEC. It just doest appear in the list box the fiel.
Hi Anbu,
I will try, thanks for your support.
Thanks all for your answers....
I figured out why the field was not being shown.
I was modified an existing App, and it had a hidden on my column, so I just had to comment the part of the script.