-
-
-
Re: Scripting error
Anil Babu Mar 18, 2017 2:55 AM (in response to Yuriy Butsan)May be try date+Rowno()-1 instead of date(+rowno()-1)
-
Re: Scripting error
Yuriy Butsan Mar 18, 2017 3:13 AM (in response to Anil Babu )Doesn't work. I have the same error.
-
Re: Scripting error
Anil Babu Mar 18, 2017 3:30 AM (in response to Yuriy Butsan)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;
-
-
-
-
-
Re: Scripting error
Anil Babu Mar 17, 2017 10:06 PM (in response to Yuriy Butsan)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?
D_temp:
load
date($(mnD)+Iterno()-1) as Д
AutoGenerate 1
$(mnD) + IterNo()-1 <= $(mxD);
WD_s:
LOAD
Date(Д) as %RoutDate,
Date(Д) as Day_,
Week (Date(Д)) as WeekNum,
MonthName(Date(Д)) as Month_,
Year(Date(Д)) as Year_,
WeekDay(Д)+1 as DayOfWeek_
Resident D_temp;
DROP Tables D_temp;
left join (WD_s) load DayOfWeek_, DayOfWeekName inline
[DayOfWeekName, DayOfWeek_
Пн,1
Вт,2
Ср,3
Чт,4
Пт,5
Сб,6
Вс,7 ];
//May be this
left join(WD_s)
load * inline [
DayOfWeekName, DayOfWeek_
Пн,1
Вт,2
Ср,3
Чт,4
Пт,5
Сб,6
Вс,7 ];
-
-
Re: Scripting error
Yuriy Butsan Mar 20, 2017 6:12 AM (in response to Anil Babu )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:)
Many thanks,
Yuriy
-