to create a new field in depence on another fieldname

[beck_bakytbek]

Hi Folks,

i got a situation, namely my table does look like:

ID, USERFIELD1, USERFIELD2

1,           70,                    30

2,           80,                    20

in the row with ID = 1, the number 70 belongs to engineer, the number 30 belong to architect.

i want to achieve this output:

ID, USERFIELD1, NewField_1,   USERFIELD2,     NewField_2

1,           70,           engineer                30                 architect

2,           80,           engineer                20                 architect

and namely if i select 70, i want to see: the engineer, i know, it does look a bit strange, but i have only this table. can i create such newfields?

Thanks a lot for your help

Beck

[beck_bakytbek]

Thanks a lot Stefan,

the table does look great, i have a question, how can add the field: Ansatz in this procedure?

[swuehl]

Shouldn't Ansatz equal USERFIELD1 resp. USERFIELD2?

[beck_bakytbek]

Hi Stefan, sorry for bother

i want to achieve this output

ID, USERFIELD1, USERFIELD2, Ansatz

1,  70,  30, 100

2,  80, 20, 80

[swuehl]

Sorry, I think it's too late for me to understand what determines the single Ansatz value you want to show in each line.

Try to describe the keys that link your two tables or the algorithm how you get the Ansatz in each line in more detail, then you should find someone here in the forum who might help you with the script syntax.

[beck_bakytbek]

Nonetheless, Thanks a lot Stefan for your help and response

[its_anandrjs]

Overall it seems you need one master table for this may be helpful for you and do the mapping or the left join on the table.

[beck_bakytbek]

Hi Anand, thanks a lot for your responce and feedback, i try to implement it