load specific fields from a table base in a rule

[#1]

Hello, all..

I got a table named TAB with the following fields:

TAB

-----------

primaryKey

info.health

name.health

info.edu

name.edu

info.org

name.org

How do I load a resident table based on this first, with 'primaryKey' and all fields terminated with "edu"???

[swuehl]

Using AS to rename fields, or

QUALIFY *;

UNQUALIFY primaryKey;

edu:

LOAD

primaryKey,

info.health,

name.health,

info.edu,

name.edu,

info.org,

name.org

FROM YourTableSource;