Transcode new Keyfield with already present Keyfield

[#1]

Hi guys,

I have a PERSONID as Keyfield and related fields(Names etc). I want to add to this datamodel completely new ID'S with respective different fields(New names) which are not there in the PERSONID. I want to transcode the ID'S with the PERSONID so that I can get the relative fields of ID'S with new names not joined but In a way replacing of the PERSONALID's with the new ID's. I donno whether I explained it clearly.. Is it possible?

Thanks

Sravan

[rwunderlich]

Sorry, I'm not understanding. Can you post some sample data to clarify?

-Rob

[#3]

Hello Rob,

I thought so.. I am attaching a doc where I think I explained it. Hope u understand..

Thanks in advance..

Sravan[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1057.TEST.doc:550:0]

[disqr_rm]

I must be missing something when I am reading. Or may be that I am in weekend mode now. 🙂

May be you just need to buid a cyclic group between these 2 IDs and put that on your charts to see results based on which attribute you select.

[#5]

Thanks Rakesh it does not help much for my usage..

Any Other ideas..to change in script or some other options..

[#6]

I cant copy the script because it is HR and the data is secured..