topic Re: Read a CSV Column into an Inline table in QlikView

Read a CSV Column into an Inline table

Thu, 17 Jan 2013 15:36:50 GMT

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

SSCD

CUSTOMER

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.

Re: Read a CSV Column into an Inline table

Nicole-Smith — Thu, 17 Jan 2013 18:40:52 GMT

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;

Re: Read a CSV Column into an Inline table

Thu, 17 Jan 2013 19:35:57 GMT

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