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)?
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)?
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
Name
, Email
, Job Title
, and ID Type
to the datatable.Employee
table and add the rows to the datatable.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.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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.