This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've two inputs (A and B) and would like to compare and update data having A as primary. For example:
Input AInput BOutput
- ID and Year are the key fields
- I'd like to update Address and Contact. If the field is null on B, keep A.
Real tables actually have 75 fields. Is there a way to create a single template formula for all 75 fields like IIF(Isnull([Field_B]), [Field_A], [Field_B]) instead of creating a formula for each field (one giant formula tool with 75 formulas) - nor using batch macros.
The easiest way to do this is to transpose both datasets so your numerous fields are all stacked on top of each other. You can then filter for where you have nulls in A and then join them with B to replace them. All that is needed is to union them back together and then cross tab to get your full data structure back.
This flow sounds like exactly what I am looking for, but I don't have the latest version of Alteryx. What version are you using? Is there a way to save this in a lower version or have created in the lower version to be able to use?