topic Re: Field not found : Adding new field in current datasource in QlikView

Field not found : Adding new field in current datasource

Sun, 07 Feb 2016 23:13:13 GMT

Hi everyone,

I am trying to add my new field to be added in current table (Field Time). However my previous data source do not have this field. I need to read my old data source (without new field), and new data source with (new field).

May I know the best way to added this new field into current table so that it will not impact the performance of reloading the qvw.

Below are my table :

FactTable:

LOAD

ID,

Date,

UserName,

Age,

Time //newfield

FROM

[..\..\..\DataSource\Test\Excel1_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

Concatenate(FactTable)

LOAD

ID,

Date,

UserName,

Age,

Time //newfield

FROM

[..\..\..\DataSource\Test\Excel2_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

Re: Field not found : Adding new field in current datasource

sunny_talwar — Sun, 07 Feb 2016 23:55:05 GMT

Assuming that Excel1 is your old datasource and Excel2 as new, you might be able to do something like this:

FactTable:

LOAD

ID,

Date,

UserName,

Age,

Null() as Time //newfield

FROM

[..\..\..\DataSource\Test\Excel1_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

Concatenate(FactTable)

LOAD

ID,

Date,

UserName,

Age,

Time //newfield

FROM

[..\..\..\DataSource\Test\Excel2_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

Re: Field not found : Adding new field in current datasource

Sun, 07 Feb 2016 23:58:40 GMT

Hi Sunny,

Thanks for reply

Just fyi Excel 1 & 2 are different table. There will be new field in both excel.

Re: Field not found : Adding new field in current datasource

sunny_talwar — Mon, 08 Feb 2016 09:09:07 GMT

If both of them will have the field then what you originally had should work:

FactTable:

LOAD

ID,

Date,

UserName,

Age,

Time //newfield

FROM

[..\..\..\DataSource\Test\Excel1_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

Concatenate(FactTable)

LOAD

ID,

Date,

UserName,

Age,

Time //newfield

FROM

[..\..\..\DataSource\Test\Excel2_*.xls]

//(html, codepage is 1252, embedded labels, table is @1);

What exactly was the issue when you used the code you posted?

Re: Field not found : Adding new field in current datasource

Mon, 08 Feb 2016 15:32:46 GMT

Hi Sunny,

The issue is my previous data, does not contain the new field which is Time. So when I reload the qvw, it prompts error.(Field not found)