Two Fields into one Field as Filter

[beck_bakytbek]

Hi Folks,

i have an situation which does look like, our customer deleloped the database, within this database we have a tables with 3 fields:

Project,   Project_Manager1,    Project_Manager2

A,               Mike,                     Simon

B,               Tom,                      Frank

C                Yoko                        Will

i know this database does look like a bit funny, but as you know : Your Customer is your King

i have a question: How can i combine these Fields: Project_Manager1, Project_Manager2 into one Field: ProjectManger

my expected Output is:

Project    and Filter as ProjectManager

A               Mike

               Simon

B               Tom

               Frank

C               Yoko

                Will

thanks a lot

Beck

[karthikoffi27se]

Hi Beck

In the script just use concate like the one below

Project_Manager1 &' '&  Project_Manager2  as ProjectManager

This should get what you want.

Many Thanks

Karthik

[beck_bakytbek]

Hi Karthik,

Thanks a lot for your feedback, but this way does not work:

my expected output is:

ProjectManager:

Mike,

Simon,

Tom,

Frank

Yoko

Will

thanks a lot

Beck

[OmarBenSalem]

Mike Simon is the same Manager? as if it was First and Last name of the person?

or u want sthing like :

A Mike

A Simon

?

[OmarBenSalem]

That answered my question:

table:

Crosstable (OptionField, ProjectManager) LOAD * INLINE [

Project,   Project_Manager1,    Project_Manager2

A,               Mike,                     Simon

B,               Tom,                      Frank

C ,               Yoko  ,                      Will

];

drop Field OptionField from table;

result:

[beck_bakytbek]

Hi Omar,

Mike is Project_Manager1

Simon is Project_Manager2

thanks

Beck

[OmarBenSalem]

check my answer above

[beck_bakytbek]

thanks a lot

Omar, this was my first option to solution, is there any another way to solve this issue?

Thanks a lot

Beck

[OmarBenSalem]

Why you're not happy with this solution?

[beck_bakytbek]

Omar, i am very happy with this solution: shukran,

i thought, what if, if my customer create a few fields within this table,

Imagine: customer creates the fileds; Project_Manager3, Project_Manager4

how can i cover another fields wth crosstable and concatenate them with another table?

thanks a lot

Beck