Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks a lot Stefan,
the table does look great, i have a question, how can add the field: Ansatz in this procedure?
Shouldn't Ansatz equal USERFIELD1 resp. USERFIELD2?
Hi Stefan, sorry for bother
i want to achieve this output
ID, USERFIELD1, USERFIELD2, Ansatz
1, 70, 30, 100
2, 80, 20, 80
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.
Nonetheless, Thanks a lot Stefan for your help and response
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.
Hi Anand, thanks a lot for your responce and feedback, i try to implement it