topic Re: Load column with a hardcoded value in QlikView

Load column with a hardcoded value

Fri, 27 Nov 2015 15:36:12 GMT

Hi,

I have a table in the below format:

ID	Value
1	100
2	500
3	200
4	150
5	700

I need to append a column to this table which has a value hardcoded into, a default value if you will.

So the result I am trying to achieve is this:

ID	Value	Period
1	100	ONE_YEAR
2	500	ONE_YEAR
3	200	ONE_YEAR
4	150	ONE_YEAR
5	700	ONE_YEAR

I've googled around for a bit, seems like Inline Loads might have something to do with it, but I can't figure it out.

Any help would be much appreciated

Thanks

Re: Load column with a hardcoded value

swuehl — Fri, 27 Nov 2015 16:18:16 GMT

LOAD

ID,

Value,

'ONE_YEAR' AS Period

FROM YourTableSource;

Re: Load column with a hardcoded value

Fri, 27 Nov 2015 16:21:23 GMT

Hi,

load inline table with two field,

ID and Period.

then make inner join for the two tables.

Re: Load column with a hardcoded value

Kushal_Chawda — Fri, 27 Nov 2015 16:27:10 GMT

another way

Load ID,

Value

From Table

join

load * inline [

Period

ONE_YEAR ];

Re: Load column with a hardcoded value

MarcoWedel — Sun, 29 Nov 2015 00:32:42 GMT

Hi,

if you can't include the additional field in your initial load of the table (e.g. because it results from a binary load or an included script file you can't change), then you can go with your second best option and join it subsequently like:

Join (YourTable)
LOAD 'ONE_YEAR' as Period
Autogenerate 1;

hope this helps

regards

Marco