topic load specific fields from a table base in a rule in QlikView

load specific fields from a table base in a rule

Sat, 16 Jan 2016 22:22:19 GMT

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 — Sun, 17 Jan 2016 01:37:24 GMT

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;