topic Re: Different Fields, Same Values in QlikView

Different Fields, Same Values

evansabres — Thu, 25 May 2017 12:59:43 GMT

I have three fields; 'User' 'Employee Rewarding' and 'Employee Awarded'

All three fields have the same values, which are employee names. Two of them come from one table, while the other comes from a different table. Ideally, I want to name the field empNME and have it be a key, linking field.

What would the solution be for this?

Re: Different Fields, Same Values

ahaahaaha — Thu, 25 May 2017 13:06:39 GMT

Hi Evan,

As variant, in both tables, you can create an additional key field with employee names, by which to link both tables, without affecting the already existing fields with employee data.

Regards,

Andrey

Re: Different Fields, Same Values

evansabres — Thu, 25 May 2017 13:07:23 GMT

Andrey,

Thank you. What is the process for doing that, apologies, unfamiliar.

Re: Different Fields, Same Values

ahaahaaha — Thu, 25 May 2017 13:12:17 GMT

For example, as variant

Table1:

LOAD

[employee names1],

[employee names1] as Key

...

From ...

Table2:

LOAD

[employee names2],

[employee names3],

[employee names3] as Key

...

From ...

Both tables will be linked by field Key

Re: Different Fields, Same Values

vamsee — Thu, 25 May 2017 13:13:11 GMT

Map:

Mapping Load Employee_Awarded as Key,

Employee_Awarded as Value;

User:

Load User,

EmployeeRewarding,

ApplyMap('Map', User, NULL()) as EmployeeAwarded

From A;

Re: Different Fields, Same Values

evansabres — Thu, 25 May 2017 13:22:51 GMT

Apologies, I am not following, perhaps because I explained the order of my tables incorrectly.

My First Table is Transactions, which has fields

'EmployeeAwarded' and 'EmployeeRewarding'

My other table is Users, which has the field, 'User'

Re: Different Fields, Same Values

vamsee — Thu, 25 May 2017 13:37:53 GMT

Same thing just interchange the column names

( or)

Map1:

Mapping Load Employee_Awarded as Key,

Employee_Awarded as Value;

Map2:

Mapping Load

EmployeeRewarding as key,

EmployeeRewarding as Value;

User:

Load

User,

ApplyMap('Map2',User, Null()) as EmployeeRewarding,

ApplyMap('Map1', User, NULL()) as EmployeeAwarded

From A;

Re: Different Fields, Same Values

vishsaggi — Thu, 25 May 2017 14:15:06 GMT

You said your EmployeeAwarded and EmployeeRewarding has employee names, you mean does these two fields has same employee names or different names. Just rename your User table Userfield to EmployeeAwarded. Like

Transactions:

LOAD EmployeeAwarded,

EmployeeRewarding,

....

FROM yoursourcetablename;

User:

LOAD User AS EmployeeAwarded,

......

FROM yourSourcetablename;

Re: Different Fields, Same Values

evansabres — Thu, 25 May 2017 14:25:49 GMT

Thank you!