Requirement on Createing fields

[#1]

Hi

how to create new fields which are not present in Database and also which are not a calculated  fields

For example:

i have table in that i have 5 fields in that i need to add few new fields

Table1:

A,

B,

C,

D,

E,

F

but now i need to add X,Y,Z which are not Present in Database not a calculated fields

expected output Should be like this

Table1:

A,

B,

C,

X,

D,

E,

Y,

F,

Z,

please help me on this requirements

Thanks

[ziadm]

Hi

Load * from Table1;

Concatenate

Load * Inline [

X,Y,Z ];

[#3]

hi

i have implemented some cross table for that table.now i need to add new fields to it

the above example i have already  tried .

[#4]

please find my Sample application

in this field section

i need to add 5.1 sample

5.2 sample

e.t.c

Note: These fields are not in Data Base

[satishkurra]

Ziad approach using concatenate and same table Name should work

[ziadm]

Adding new field  works only by joining tables using join or concatenate.  Creating new fields on the fly does not work

are you adding new field or data to the field value

please share your excel data file

[satishkurra]

Add the below lines of code to get 5.1,5.2 ....

'[5.1 Sample]' as "5.1 Sample"

[#8]

i did concatenate the added values are showing in listbox but not in Straight Table(i applied cross table here)