Combining multiple fields into one

[Anonymous]

Hello Everybody.

I have an issue.

Suppose I have 3 fields

Category 1

Category 2

Category 3.

Now I want to cretae a list box as Category where all these three category values reside.

I know I can easily do it at script level by concatenating all these fields, but in real scenario I have many fields of this type , and by this way I would be creating many synthetic keys.

Therefore I want to achieve it at front level only..

Any Ideas,,,,,,,,,,,

Regards

Nitin

[tresesco]

Using like: [Category 1]&[Category 2]&[Category 3] , or, using Concat() function................?

[#3]

Hi Nitin

As of my understood PFA hope this will helps you

Regards

Nirmal

[Anonymous]

PFA

I need to create a list box having all values of Category 1,
Category 2, Category 3.

If i use concate or &, this will create a list box but I cannot select it suppose Category 1and Category have same value Large,

then Large cannot be selected.

[tresesco]

Best aproach would be concatenating the tables (as you mentioned you can). Though I didn't get the point of getting synthetic keys, that too can be overcome. 

[#6]

Using This: [Category 1]&[Category 2]&[Category 3]  as Combine_Fileds, or, using Concat() function..............

[#7]

Hi Nitin

Hope this will help you.......PFA

[#8]

hi

try according to this

original_table:

load

category1

category2,

category3

from table;

Tab1:

load

category1 as combined

resident original_table;

join

Tab2:

load

category2 as combined

resident original_table;

join

Tab3:

load

category3 as combined

resident original_table;

Drop table original_table;

[#9]

Hi,

Please find the attached file.

Hope it help....

[Peter_Cammaert]

What are you trying to accomplish really? Put all Cat 1,2,3 values in the same list box? How will these values connect to the original records? What will happen if you select two different values from this list box: will you get facts that correspond to either value (OR-mode) or do you want facts that have both values somewhere in Cat 1,2 or 3 (AND-mode)?

Moreover, many of the examples shown will duplicate the facts because they move from a single record with three fields to three copies with a single field. Is that what you want?

Peter