Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two tables A, B. table A and B is joined by column id . i have created a straight table with column att_name as a dimension from table A and 4 expressions . i have text box which should display att_name_desc for all 4 expressions from table B when I select att_name in straight table. i am using
concat(att_name_desc ,',')
in text box which works fine if I have one id for each att_name. but I am not getting any att_name_desc if I have 2 or more id.
can some one suggest a solution.................
Thanks in advance
hi
try this
Aggr(concat(att_name_desc ,','),att_name)
hi Kumar,
I have used formula you suggested .i am getting att_name_desc for all att_name.but I need only
att_name_desc for selected att_name in straight table
Hi Charan,
Please gp through the below.
I believe it is as per your requirement.
Hi.
Have you tried concat(DISTINCT field)?
I am getting att_name_desc and att_name from two different tables
I tried it.but I am not getting results as expected
Send an example.
You want to caoncat fields?
Field1 & Field2
Hi Charan,
If you have these fields in your tables then it will work.
Can you please post a sample to check it furthur?