Get the date in the New Column and ignore null values

[arsalanzaki]

Hello champs,

I have three columns (Extracted_HO_Date1, Extracted_HO_Date2 and Extracted_HO_Date3) and the date will be in any one of these columns. I want to get the date in a new column (Extracted_HO_Date) and ignore the Null values.

I have attached the file showing the desired outcome, can you please help?

[flying008 · Accepted solution]

Hi, @arsalanzaki 

Trim(ToString([Extracted_HO_Date1]) + ToString([Extracted_HO_Date2]) + ToString([Extracted_HO_Date3]))

[peterr_h]

Hi @arsalanzaki,

Please see the attached workflow.

I'm not sure of the format of your dataset, but for the dummy dataset that I created (with a format I believe will be similar to yours), this will work and scale nicely.

The only thing to watch is if a certain entry has more than one date field populated - I would advise adding some Test tools to ensure that this doesn't corrupt your results (otherwise you will end up with multiple rows per entry).

Further to this, the datatypes will need tweaking to whatever you need them to be, but this is a simple task.

Please let me know if you have any questions.

Best,

Peter