[ASK] how to add new column in qlikview

[#1]

hello qlikview people..

i have problem with loading data (edit script)

i want to load a table, but i also want to add new column with my own static data

for example i have table Test, with column :

id, name, contactnumber

when in edit script, i want to add one more column (example : author)

with only 1 kind of data (example : column author is only fill with record "Bobby" for all rows)

how to do that?

many thx..

[#2 · Accepted solution]

Simply do something like :

load

id, name, contactnumber, 'Bobby' as author;

sql select ...

[#3]

Renaud.Charlet wrote:
Simply do something like :
load
id, name, contactnumber, 'Bobby' as author;
sql select ... <div></div>

ok thx Ren..

it worked