How we can Concatenate two column data in one
Hi All i need your help,
I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn
example :
table 1 table 2
Column name : Hospital Name Column name : Service
Value : Apollo Value : Cardio
: GB Panth Gayno
Hi All i need your help,
I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn
example :
table 1 table 2
Column name : Hospital Name Column name : Service
Value : Apollo Value : Cardio
: GB Panth Gayno
: Apple Ortho
Pedia
ENT
requirement is hospital might have multiple services so ,on every hospital name I want to club the service and want to display in dropdown
like Apollo - Cardio
GB Panth - Cardio
Apple - Ortho
please help me for the same
thanks in advance
Accepted Solution
Updated: 26 Jan 2024 11:54 EST
Aaseya IT Services Pvt Ltd
SA
HCL Technologies Ltd
IN
@intisarm
Hi All i need your help,
I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn
example :
table 1
Column name
: Hospital Name
Apollo
GB Panth
@intisarm
Hi All i need your help,
I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn
example :
table 1
Column name
: Hospital Name
Apollo
GB Panth
Apple
table 2
Column name :
Service
Rows Name
Cardio
Gayno
Ortho
Pedia
ENT
requirement is hospital might have multiple services so ,on every hospital name I want to club the service and want to display in dropdown
like Apollo - Cardio
GB Panth - Cardio
Apple - Ortho
please help me for the same
thanks in advance
Aaseya IT Services Pvt Ltd
SA
Create the Data page and Take source as report definition. In report definition, To combine the data from two tables, you can use a JOIN condition in the Data Access tab. Specify the tables and the appropriate JOIN condition to link them. Use the Response Data Transform to add in to the single property and Use the same data page in the dropdown configuration.
HCL Technologies Ltd
IN
@Hitesh Jain Hi Hitesh thanks for your response but the method which you mentioned that i too know but im expecting the logic in DT ,as an example
even i tried to use direct concatination function in RD but i'm not aware how i can call this function to the dropdown
so if possible please give example for logic
thanks.
Accepted Solution
Updated: 26 Jan 2024 11:54 EST
Aaseya IT Services Pvt Ltd
SA
HCL Technologies Ltd
IN
@Hitesh Jain Thanks Hitesh ,
i was confused about joined table data ,finally i achieved it
Thanks for your help
@intisarm
Directly use property with as mentioned below
FirstName + " " + .LastName