topic Re: Creating new field in a table in QlikView

Creating new field in a table

alec1982 — Wed, 01 Aug 2012 18:27:45 GMT

hi,

Anybody can help me creating a new field on a table so i can match it connecet it to another table.

The first table has

ID Currency

1 $

2 $

3 AUD

4 BRL

The second table has:

Description Factor

$ to $ 1

AUD to $ 1.051

BRL to $ 0.488

I need to create a field in the first table to show Currency value & 'to $'

Thanks,

Alec,

Re: Creating new field in a table

MayilVahanan — Wed, 01 Aug 2012 18:38:21 GMT

Try like this,

Load Currency & ' to $' as Currency1;

Load * from tableName;

Hope it helps

Re: Creating new field in a table

alec1982 — Wed, 01 Aug 2012 19:13:35 GMT

Hi,

Thanks for the replay.

I got the following error:

Out of Physical and/or logical memory

Thanks,

Alec

Re: Creating new field in a table

MayilVahanan — Wed, 01 Aug 2012 19:29:24 GMT

Can you post a sample?

Before include that line. did u get any error message?

After include the following lines, you got error message?

Load Currency & ' to $' as Currency1;

Load * from tableName;

Re: Creating new field in a table

alec1982 — Wed, 01 Aug 2012 19:34:49 GMT

Hi,

I just tried to do it now inside the table load as a field

Load

Currency & ' to $' as Currency1

from table1.

It seems to work fine. Any advice on that?

Thanks,

Alec

Re: Creating new field in a table

MayilVahanan — Wed, 01 Aug 2012 19:37:20 GMT

Both are same. I thought you are using inline function.. So i referred to use like that.. Its fine..You can use Currency itself as fieldname..

Re: Creating new field in a table

alec1982 — Wed, 01 Aug 2012 19:54:07 GMT

Thanks for your help!