Populating data from another column

[umarfarooq22]

I have some data in an Excel. In Alteryx, I wish to populate an empty column with data from another column.

How will I be able to do this?

For example, I want to populate the empty rows in first two columns with Haaland.

Kindly assist

Thanks

[JosephSerpis]

Hi @umarfarooq22 you could use a formula tool for each of those columns with two IF statements or a Multi-Field Formula with one IF statement. An example formula would IF Isempty([Goals]) then Haaland Else [Goals] endif. The If statement would check if the row was empty (blank or Null) and input Haaland if this condtion is meant otherwise keep the data from Goals if the condtion was not met.

[flying008]

Hi,@umarfarooq22 

Maybe you can use Multi-Field Formula tool to get it :

iif(isempty([_CurrentField_]),[Assists],[_CurrentField_])

*****

If it is your want , please mark this a solution to help more people faster.

[grazitti_sapna]

Hi @umarfarooq22 , I have created the workflow using formula tool to meet your expectations. By your query what I understood is you want the null values in [Goal] and [Expected Goal] to be replaced by the values in [Assists] columns. So if this is the case then you can follow my workflow and please mark my solution as accepted. Else if you want nulls to be replaced with hard coded value "Haaland" for all the null values in future records then in that case you just have to replace [Assists] with "Haaland" in the workflow.

Thanks!!

[umarfarooq22]

Thanks all. I was able to use formula tool and add in the column for a specific column output