topic Re. :Data files without column headings in QlikView

Data files without column headings

Fri, 20 Aug 2010 13:19:28 GMT

I have a set of data in pipe-delimited text files, which are extracts from various DBs. These extracts have no column headings.

The column heading definitions have been provided in another set of files as sql field defintiions. These files have this sort of layout:

1 SQLCHAR 0 0 "|" 1 acct_no
2 SQLCHAR 0 0 "|" 2 bil_acct_type
3 SQLCHAR 0 0 "|" 3 id_no
4 SQLCHAR 0 0 "|" 4 sub_no

Considering I'm working with about 200 data files, each with a definition file, I'm looking for a logical way to apply the field defs to the file on load. Can anyone give me an idea?

Thanks a lot!

Brian

Re. :Data files without column headings

martin59 — Fri, 20 Aug 2010 14:49:21 GMT

Hi,

Look at the attached QVapp. We have a table with FieldNames and another with datas.

RENAME FIELDS USING ...; rename all fields with datas form the first table.

Hope it helps you

Re. :Data files without column headings

Fri, 20 Aug 2010 16:44:15 GMT

Thanks, Martin.

That works!

I am now building up the Mapping table by loading in the files that contain the field definitions. Then I can rename fields in each table as I load it.

Is there any alternative method?

Brian