How we can Concatenate two column data in one

General
, , ,
1

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

2

@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

3

@intisarm

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.

4

@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.

5

@intisarm

Directly use property with as mentioned below

FirstName + " " + .LastName

6

@Hitesh Jain Thanks Hitesh ,
i was confused about joined table data ,finally i achieved it
Thanks for your help