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: 
priyarane
Specialist
Specialist

key creation

Hi Community,

We have data like below

g2.PNG

Based on the above data we have created pivot data like below

g1.PNG

Now challenge is, I need to create a key for associaton between 3 tables (3 is  another table, from there we are getting values) to get account name. Key column is Account code. so how to to create key, some one can pls help me.

- Priya

1 Solution

Accepted Solutions
priyarane
Specialist
Specialist
Author

I have got solution, thanks for you time

View solution in original post

8 Replies
vikasmahajan

Parent Account Code & '-' & Account Code  as Key  create this key while loading 3 tables.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
priyarane
Specialist
Specialist
Author

but here we are taking only under A000000_IAS account codes in the second table...

PrashantSangle

Hi,

It is difficult to suggest with limited information.

we don't know what type of data other 3 tables contain.

from above 2 table which table you are loading in qv?

Please elaborate you requirement to get solution.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
priyarane
Specialist
Specialist
Author

These 2 excel and one more table from Database....first table which we got from customers and second which we have created as per the requirements... account code is the key column between DB and first excel table... but we have created second table which have Paren, Child1, Child2.....etc... so here how to create association between created excel (second table) with Database and first excel table....

Anonymous
Not applicable

As you are saying that your 1st table is already associated with DB table . then if you create association between 2nd table to DB table & 1st Table . It'll lead to Circular Loop .

priyarane
Specialist
Specialist
Author

I have got solution, thanks for you time

Anonymous
Not applicable

Can you share your solution please .

priyarane
Specialist
Specialist
Author

key should be based on last column and to get desc, I have used Apply map