UiPath Apps - Showing values from 2 tables in 1 table view

Help Apps
,
1

I have 2 tables:
1 - Employee table ( Email, Name, Job Title)
1 - ID Details ( Email, ID Type, ID Value, Attachment)

How can I show the data in a datatable wherein it shows (Name, Email, Job Title and ID Type)?

2

Hi @Yu_Richmond ,
They match by Email?
That’s right?
You can
1-insert column ID type in table Employee
2-compare with table ID Details to get value ID type
3-change index of cloum
Regards,
LNV

3

@Yu_Richmond

  1. Create a new datatable.
  2. Add the columns Name, Email, Job Title, and ID Type to the datatable.
  3. Loop through the Employee table and add the rows to the datatable.
  4. Loop through the ID Details table and add the rows to the datatable if the Email column in the ID Details table matches the Email column in the Employee table.
  5. Display the datatable.
4

@Yu_Richmond ,

Data Service and UiPath apps do not have any ADVANCED Operation supported like LEFT JOIN, INNER JOIN,FULL JOIN or two data source operation together.

So this is not possible direct either apps or data services.

In order to do that. I would say create a Process and in process call your two entity using data service connection and store into Data Table based on your business logic and Make Data table as out Argument into process.

Test the process manually from orchestrator and verify result. If this looks good then integrate process into APPS and show result of Data table into DISPLAY Control .

Thanks,
Arvind

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.