how can hard code the min date

[Anonymous]

I am testing my data and only want one financial year to load.  how do I hard code the Financial year  14/15?  for some reason hard coding the variables min/max year doesn't work?

Cheers,

Laura

[tresesco]

How does your data look like? Could you explain with an example?

[jagan]

Hi,

Can you attach some sample data?  If you want to restrict in script then try like below

LOAD

*

FROM DataSource

WHERE FinancialYear = '14/15';

Hope this helps you.

Regards,

jagan.

[engishfaque]

Dear Laura,

Have a look into attached sample file.

Kind regards,

Ishfaque Ahmed