Read a CSV Column into an Inline table

[#1]

Does anyone know how to read a CSV column into an inline table?

I have the following inline table created:

load *  Inline [ResSel,

success

Success

PLANNING

SALES

REPAIR

PRODUCT MANAGEMENT

TPL VENDOR MANAGEMENT

CUSTOMER / PARTNER

OM

SSCD

CUSTOMER

IT

MANUFACTURING

TAC/OM

TPL CONFIG TEAM

TSTR

TAC

]

However the field values are manually taken from the distinct contents of a CSV file column "ResSel" . I would like to be able to read the inline data from the CSV column "ResSel" and populate the inline field with the distinct data when I load. That takes are of a situation where a new field value shows up in the data and so will automatically get added to the inline data.

Any ideas would be appreciated.

Jim.

[Nicole-Smith · Accepted solution]

Why not just load the distinct values of that column from the .csv all of the time?  (Get rid of the inline table that you currently have, and just use the .csv file.)

Table:

LOAD DISTINCT ResSel

FROM File.csv;

[#3]

Duh - yes I just realized that I could load the field a second time to make it an island - I need it as an island - i.e. not joined to the rest of the data - thanks Nicole