topic Re: Adding header to data in QlikView

Adding header to data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a simple question but could not find the answer yet.

I have multiple files of data without header that I need to process. I have a list of header that can identify each column for these files.

Also, not all of the columns will be used when loading the data, so it will be partial load too.

What is the best way to do this?

Re: Adding header to data

Anonymous — Thu, 02 Jun 2016 23:19:33 GMT

The question is actually while the columns can be named easily, is it possible to manipulate the newly defined column names with some operations, such as left(newly defined column, 3), Date (newly defined column name) etc?

When I did this and load the data the script did not recognize this field so I had to use the column number instead of new field name.

Re: Adding header to data

trdandamudi — Thu, 02 Jun 2016 23:59:03 GMT

Can you please share some sample data and the desired output so that we can take a look,

Re: Adding header to data

Anonymous — Fri, 03 Jun 2016 00:47:56 GMT

This is the example of the script I use:

LOAD @1 as Date, @2 as [ Time],

@3 as [ IP address],

@4 as Field D, @5 as Field E,

@6 as Field F, @7 as Field G,

Date (Date, 'DD/MM/YYY')&' '& @2 as [Time Stamp],

Left(Filed G,5) as Hardware_Type

FROM

File Source;

Where Time Stamp >'26/05/2016';

The above script did not work unless I change

Date (Date, 'DD/MM/YYY')&' '& @2 as [Time Stamp],

Left(Filed G,5) as Hardware_Type

Date (@1, 'DD/MM/YYY')&' '& @2 as [Time Stamp],

Left(@7,5) as Hardware_Type

and also Where Time Stamp >'26/05/2016'; to Where T@1 >'26/05/2016';