Create one table from 3 columns

[beck_bakytbek]

Hi Folks,

i got a question, my tables does look like:

Table: EmplResults

Nr, Empl1,Empl2, Empl3

1, 1, 4, 5

2, 2, 3, 2

3, 1, 5, 5

as you see i have 4 fields within my table, my issue is, to create a table (Rating Scale) on base of 3 Fields like: Empl1, Empl2, Empl3 for instance:

Rating, Scale

1, ok

2, normal

3, good

4, very good

5, super

Later if i create the Rating-Scale Table i want to concatenate it with my above Table: EmplResults, to show the Scale of Results for Employee.

Does anybody have any idea how to solve this issue? Any Feedbacks and suggestions are appreciated.

Thanks a lot

Beck

[Zhandos_Shotan · Accepted solution]

Hi

Use CrossTable load...

and Mapping load, ApplyMap for rating replacement

[beck_bakytbek]

Zhandos,

thanks a lot for your responce, do you have an example?

raxmet

[beck_bakytbek]

thanks a lot for your time and help

[Zhandos_Shotan]

Crosstable(Employees, Rating) Load

*

resident EmplResults;

Join

Rating,

Scale

Resident Rating_Scale_Table;