[ASK] how to filter data that load to QVW from edit script

[#1]

hello...

i wanna ask a question

how to load data but only certain date?

example, i only want to load data that in year 2010

can i use SET function?

b'coz if i use where statement, it will take a while to wriite since tables is pretty much

thx...

[sparur]

Hello

you can use variable in load script:

SET vYear = '2010';

LOAD ... FROM,,,

WHERE [Year] = '$(vYear)';

[#3]

hello sparur

thx for ur reply

i've tried that way

and unfortunately, the table with date isn't only 1

so what do i want that can i use 1 syntax/function to represent year in every table that contain date?

can i do that?

thx..

[sparur]

yes. you can use vYear variable in any LOAD statement. Or you can create new variable (with date for example) for restriction data. or you can modify vYear variable into different year and use it with new value.