Hello,
Please help me to join the attached data.
Have copied the expect output in sheet 2
Hi,
Could you provide more details about what you are attempting to do? What is the join rule? What is happened? What is the problem?
Hello,
So what I wanted is that I have two record date columns(Column V and W) and wanted the details to get copied in column N. The rule that i wana set up is if column V has the date then copy whats there is cloumn W
Hi @Devika
That's not really a join. You just need to use a formula tool to update the [Record date] field (in alteryx you use the field names, not column letters). A formula for this might look like:
IF !IsEmpty([Record Date3])
Then [Record date2]
Else [Record date]
Endif
We have a 'Record Date3' field because you have multiple fields named record date - alteryx needs unique field names.
Give this a go and attach your workflow if you still have problems.