Data Join

[Devika]

Hello,

Please help me to join the attached data.

Have copied the expect output in sheet 2

[fvilelabr]

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?

[Devika]

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 

[Luke_C]

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.