topic Re: how to create a new column filled with '1' in QlikView

how to create a new column filled with '1'

Tue, 26 May 2015 12:09:35 GMT

Hi all,

my short question:

how can i create a new column filled with '1' in every row in an existing table.

I need it to count my data without the 'count' command.

best regards

Philipp

Re: how to create a new column filled with '1'

Tue, 26 May 2015 12:13:25 GMT

my short answer: just type 1 into a new expression

Re: how to create a new column filled with '1'

maxgro — Tue, 26 May 2015 12:16:57 GMT

if I understand, in the load script

load

field,

....

1 as newfield,

....

from

.....

but why you don't want count?

Re: how to create a new column filled with '1'

Tue, 26 May 2015 12:16:59 GMT

Sorry but i don't understand your idea... i need a column named 'DataCounter' that have as much as rows like the other columns in this table. But 'DataCounter' has a '1' in every row.

Re: how to create a new column filled with '1'

simospa — Tue, 26 May 2015 12:17:17 GMT

Another short answer 🙂

LOAD field1

field2,

...,

fieldn,

1 as myCounter

FROM ...

Re: how to create a new column filled with '1'

MayilVahanan — Tue, 26 May 2015 12:20:33 GMT

Try like this

Load *, 1 As DataCounter

from sourcetable;

Re: how to create a new column filled with '1'

Tue, 26 May 2015 12:22:14 GMT

Load *, 1 as DataCounter from Table1;

Re: how to create a new column filled with '1'

Tue, 26 May 2015 12:23:48 GMT

This is why the long more detailed question is more helpful

You talk about a new column which sounds like a new expression in a chart, creating a new expression with just '1' in it will do just that in a chart.

Actually though it sounds like you a looking for a new field in your data model, now you have given a bit more detail.

For that you can simply add a new field to your load

1 As DataCounter

hope that helps

Joe

Re: how to create a new column filled with '1'

Peter_Cammaert — Tue, 26 May 2015 12:43:33 GMT

Or if your table already exists (and you don't wanna change the LOAD statement - or you can't), use this:

JOIN (ExistingTable)

LOAD 1 AS RowCounter

AUTOGENERATE 1;

We should test which is faster: another LOAD RESIDENT or a simple JOIN. Massimo's original table LOAD moditifcation will beat everything else...