Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bouderbc
New Contributor III

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??

Life is so rich, and we need to respect to the life !!!
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
New Contributor III

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

    

bouderbc
New Contributor III

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.

Community Browser