Hi
i need help.
i have used column to split tool to split a column having employee name and joining date in one column.
example:column name: Employee info
Abc- 5/8/2019
i have used column to split
and then used cleaning data and select to select the date field which i need.
and then used datetime
and converted it into correct format. And then used formula tool to create a column i.e Unique Id
id+ dept
now when i am using find and replace tool
and used
find within field as: some field from above workflow
and find value: unique id
and append fields to record: i have selected
Unique id
and joining date column which i specify in datetime new column name
but after running the workflow
my unique id and joiningg date column
can someone help me to figure this out why the outpit is blank for find and replace tool
