Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bouderbc
Creator
Creator

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

14 Replies
sunny_talwar

May be just this

LOAD ....,

     'F' as Data

FROM ...

Anil_Babu_Samineni

One simple solution occurs

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

OR

Rename Command??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Master II
Master II

LOAD

'F' AS Data

FROM  [table name]

;

Learning never stops.
its_anandrjs

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

its_anandrjs

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
Creator
Creator
Author

    

bouderbc
Creator
Creator
Author

sunny_talwar

LOAD 'G' as DATA

Is this not working for you?

its_anandrjs

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