Hi All,
In my data load editor, In my first section I have added an sql query(Table 1) and in the second section I have created an Mapping table and resident to above Table 1. Then in same section, I have a new table(Table 2) and added all fields from Table 1 and resident to Table 1. Then I have dropped the Table 2;
Then app has other sections as well! Now I need to partial load this. Added the keyword in front of select statement in table 1, and in front of load statement in Mapping & Table 2. I have a enabled button action to partial reload. Is this partial reload done in the correct way or what's the best way to define it ?
Table1:
Add SQL select m.MATREQ_BASICID ...
Map_Max_Rate:
Mapping
Add LOAD PACKING_DOCID&PITEMCODE, max(COSTRATE)
Resident Table1
Group By PACKING_DOCID&PITEMCODE;
Table2:
Add LOAD PACKING_DOCID, ... as LINK1 Resident Table1;
Drop table Table1;