Need to create a field which refers multiple field from multiple table

[#1]

Hi friends,

I Need your help.

I need to create a new field, which referes the multiple field which is imported from multiple table.

Here i have attached the example document.

But i need a example, how to import multiple fields from multiple QVD files.

Example:
table 1-field11,field12,field13.

table2-field21,field22,field23.

i need to create new field with field11 and field23.

i.e,

new_field-field11,field23.

If i create a list box for new_field it displays the filed11,field23.

Hope i will get exact reply with good script quickly.

Thanks in advance.

[#2]

Just a list box ? Give &field11&','&field23 as the <expression> as the List box field.

--Arun

[#3]

Hi Arun,

Thanks for your quick reply.

I don't need to display the data's in the list box. I just need to display the field name.

example:

------------------------

new_field(list Box)

Field11

Field23

-------------------------

Thats all.

[#4]

Then you need to use system fields.

Give the following expression in the list box:

=if(left($Field,5)='Field',$Field,null())

This should work.

--Arun

[#5]

Sorry, i tried. I get some problem. Not the exact result.

Also could you explain what the code do.

Did you find the attachment attached in this forum.

I need the Dimension and Expression like the same, but by importing from QVD file.

Again thanks for your Reply and Idea.

[#6]

I have found the solution and it is working fine. Thanks for the members who suggest and help me to doing this.

[#7 · Accepted solution]

I first loaded all the fields from the table, then i created a new field then loaded the fields which are necessary into it.

[#8]

Hi Srinivasan,

Can u attach a sample application of it.. "Creating a new field..."

Thakns in advance...

[#9]

Hi Srinivasan,

Can u attach a sample application of it.. "Creating a new field..."

Thanks in advance...

[#10]

Hi Ashok,

This is the one which i got from a sales support.