Discussion Board for collaboration on QlikView Scripting.
What does it mean? Help me, please
I have scripting error at the start.
date($(mnD)+Rowno()-1) as Д
Date(Д) as %RoutDate,
Date(Д) as Day_,
Week (Date(Д)) as WeekNum,
MonthName(Date(Д)) as Month_,
Year(Date(Д)) as Year_,
WeekDay(Д)+1 as DayOfWeek_
DROP Tables D_temp;
left join (WD_s) load DayOfWeek_, DayOfWeekName inline
Can you share that error screen shot or run your script in debug mode and see where exactly it is failing?
May be change it to bold one. Here, I assume mnD, mxD are variables and meantime, can you confirm the red bold whether what those values?
date($(mnD)+Iterno()-1) as Д
$(mnD) + IterNo()-1 <= $(mxD);
//May be this
load * inline [
May be try date+Rowno()-1 instead of date(+rowno()-1)
Doesn't work. I have the same error.
Would you share QVF File, Please?
DROP Tables D_temp; // Please change to below because here you are dropping single Table only not more than one
DROP Table D_temp;
Thank you very much. It was very helpful for me.
I had some changes in CSV file (added two columns), that's why I couldn't load data.
This is my inattention