Scripting error

[#1]

What does it mean? Help me, please

I have scripting error at the start.

D_temp:

load

date($(mnD)+Rowno()-1) as Д

AutoGenerate 1+$(mxD)-$(mnD);

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 ];

[vishsaggi]

Can you share that error screen shot or run your script in debug mode and see where exactly it is failing?

[Anil_Babu_Samineni]

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 ];

[#4]

!

[#5]

[Anil_Babu_Samineni]

May be try date+Rowno()-1 instead of date(+rowno()-1)

[#7]

Doesn't work. I have the same error.

[Anil_Babu_Samineni]

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;

[#9]

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