Hello Every one,
I have critical a scenario in my organization. Where we are pulling users data from one of the organization into our Servicenow table through data source.
We write query to pull user data form various columns in table "A". But I want to get one additional latest version of colum details of the user which is not present table "A". The colum is available in another table "B".
So i am trying to embadded the column details in my query to get the data from other organization.
Wring the below query to get data depends on Created date to get latest user record details.
"max(Create_date) as column B "
Added additional coulmn in data source transform map. Added the source table "B" and mapped with target user table.
But this is not working as expected. Can any one suggest this is right approch to get data in SN?
I am not sure where my code getting broke.
Query not fetching date from organization or transform map getting failed to map the target table?
Can any one suggest on my query. It will be more helpfull!
Thank you
