Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Create one table from 3 columns

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

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi

Use CrossTable load...

and Mapping load, ApplyMap for rating replacement

View solution in original post

4 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi

Use CrossTable load...

and Mapping load, ApplyMap for rating replacement

beck_bakytbek
Master
Master
Author

Zhandos,

 

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

 

raxmet

beck_bakytbek
Master
Master
Author

thanks a lot for your time and help

Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Crosstable(Employees, Rating) Load

*

resident EmplResults;

 

Join

Rating,

Scale

Resident Rating_Scale_Table;