Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bouderbc
Contributor

How To fill all the fields of a column with the same field (another value)?

Hi Experts,

How To fill all the fields of a column with the same field ? without using Load if , cause i have many fields to load

Thanx

Example :

Column: Data

Fields: A B C D E

Replace All the fields with : F

Result: F F F F F

Thanx

Regards

Ali

Tags (1)
14 Replies

Re: How To fill all the fields of a column with the same field ?

May be just this

LOAD ....,

     'F' as Data

FROM ...

Re: How To fill all the fields of a column with the same field ?

One simple solution occurs

Load *, 'F' as Field From ...

OR

Rename Command??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Honored Contributor II

Re: How To fill all the fields of a column with the same field (another value)?

LOAD

'F' AS Data

FROM  [table name]

;

Learning never stops.

Re: How To fill all the fields of a column with the same field (another value)?

Without load means on the load Script you do not need to do this.

Re: How To fill all the fields of a column with the same field (another value)?

In this

Example :

Column: Data

Fields: A B C D E

Replace All the fields with : F

Result: F F F F F

You write Fields: A B C D E to be change with F you need to change the fields data or rename the field name be specific please.

bouderbc
Contributor

Re: How To fill all the fields of a column with the same field (another value)?

    

bouderbc
Contributor

Re: How To fill all the fields of a column with the same field (another value)?

Re: How To fill all the fields of a column with the same field (another value)?

LOAD 'G' as DATA

Is this not working for you?

Re: How To fill all the fields of a column with the same field (another value)?

Find the attached did you looking for this. Or elaborate more on the requirement.