Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"???
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;