Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[DATA]:
LOAD
'1162' as IDcounter,
'IM16706505' as ID,
date('41485.940335648' + RowNo() - 1) as OpenDays,
'41485.940335648' as CreationDate,
'41279.686145833' as CloseDate
AutoGenerate('41279.686145833' - '41485.940335648' + 1)
Autogenerate parameter must be a positive integer
('41279.686145833' - '41485.940335648' + 1) returns -206
Autogenerate parameter must be a positive integer
('41279.686145833' - '41485.940335648' + 1) returns -206
Yes, Clever is right, USE INTEGER while using AUTOGENERATE