topic Re: Using 2 data sets with no common fields to create a new column using IF statements in Alteryx Designer Desktop Discussions

Using 2 data sets with no common fields to create a new column using IF statements

sureslala — Sat, 05 Feb 2022 16:00:36 GMT

Hello

I have 2 separate data sets with no common fields between them and I want to create a new column in the first data set using 'IF Statements' referencing the second data set.

In the excel sheet attached, highlighted column C is the new column I want to create referencing the table next to it in columns G to I. Column B is 2,255 rows in my actual workflow but I have reduced it to 112 rows in the excel sheet attached.

I've created the 2 data sets in Alteryx but I'm struggling to see how I can join the 2 data sets with unique columns headers to create the highlighted column using nested 'IF' statements. I've attached a copy of my Alteryx workflow which shows how I have created the data columns that represent the columns in my excel sheet.

In the attached Alteryx workflow, I have my 2 data sets. I somehow need to combine them, then create a new column against the dates in the 1st data set using 'IF' statements, hope this is clear, happy to answer any questions anyone has!

Any assistance would be greatly appreciated please!!

Thanks

Sures

Re: Using 2 data sets with no common fields to create a new column using IF statements

Qiu — Sun, 06 Feb 2022 00:01:09 GMT

@sureslala
I prepared something like this . hope it will work for you.

Re: Using 2 data sets with no common fields to create a new column using IF statements

sureslala — Mon, 07 Feb 2022 22:21:47 GMT

Wow!! thanks Qiu!

There's no way I would have cracked this problem, your solution works perfectly and I've now incorporated it into my workflow.

Thank you very much for your time!

Cheers

Sures

Re: Using 2 data sets with no common fields to create a new column using IF statements

Qiu — Mon, 07 Feb 2022 23:19:47 GMT

@sureslala
Glad to help and thank you for the accept mark. 😁