Concatenated key

[#1]

Hi,

Can anyone explain me what is the use of concatenated key and why it is used?

(i.e) cust_id & store_id & invoice_id as %key_id

Regards,

Logesh

[Gysbert_Wassenaar]

You can find some uses in this document: Generic keys

[#3]

You create a uniq key between tvo tables. In your example I guess that same inovice id and cust id can exist in diffrent stores. By adding the store id and cust id you create a uniq key that ties data in diffrent tables togheter.

[SunilChauhan]

some times we are not able to differenciate b/w two tables based on one key. in fact

spme times we need to find the data  matching from two tables and not able to find based on one key

then we can concatenate key  and they  find it

for eample

Emp   Department   sales

123     10           200

123     20          300

hope this helps

[#5]

Hi,

i found ur answer was helpful.by using this key (cust_id & store_id & invoice_id as %key_id) if i want to create a chart with x axis as cust_id and y axis as sum(sales) then how do i?

Do i need to use subfield function to fetch cust_id like tat??