Loading specific data

Tue, 01 Apr 2014 23:22:18 GMT

I have to tables witch I load into QV but befoe loading I whanted some types of records not to be loaded, but the controling field is on another table. The script I have is this one:

LOAD "mvs_ano",

"mvs_periodo",

"mst_seq",

"scd_cod",

"sar_cod",

"trc_cod",

"ntr_cod",

"mvs_qtd",

"mvs_vlcusto",

"mvs_vlvnd",

"mvs_docint",

"mvs_docext",

"mvs_dtdoc",

"mvs_dtmov",

"arm_cod",

"mvs_utlz",

"mvs_prcusto",

"mvs_prvnd",

"mvs_data",

"arm_destino";

SQL SELECT *

FROM PUB."st_movim";

Left Join

LOAD "mst_seq",

"mst_codart",

"mst_descr1",

"mst_descr2",

"mst_codest",

"mst_marca";

SQL SELECT "mst_seq",

"mst_codart",

"mst_descr1",

"mst_descr2",

"mst_codest",

"mst_marca"

FROM GEST001.PUB."st_mestr";

.....

And I whanted to import from "st_movim" table only specific "mst_codest" records I don't know much of SQL so how can this be arrenged so the relation is made before importing data.

I have another problem from the records I import I whanted to have de last value "mvs_prcusto" for sar_code=XX and records ordered by "mvs_data", I tried to look at the sintax of FirstSortedValue(), but I don't understand the parameters, and in this case i wanted the lastsortedvalue.

topic Loading specific data in QlikView

Loading specific data