Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHaving the ability to specify columns to be "coalesced" (essentially filled in automatically when records aren't present) across all inputs of the Join Multiple tool would be very useful, and save lots of tedious setup. In fact, I avoid that tool if possible, currently, because of the extra steps necessary in maintaining key column integrity after the join.
In the screenshot below "RecordID" is present in all 4 inputs. When they are joined together, however, not every record is present in all inputs, therefore each of the 4 "RecordID" columns has nulls. We then have to go through an extra step to find the first "non-null" record ID, and put that in a new column (or in the first "RecordID" column).
This could be simply fixed by adding a menu to specify columns that should be coalesced, or auto-filled from other inputs if it's missing in the first one.
The columns in the menu could be based on the first input, and then alteryx would look for columns with the same name in all other inputs and complete the logic below, for instance:
If isnull([RecordID]) then
if isnull([Input_#2_RecordID]) then
if isnull([Input_#3_RecordID]) then
[Input_#4_RecordID]
else [Input_#3_RecordID] endif
else [Input_#2_RecordID] endif
else [RecordID] endif
Você deve ser um usuário registrado para adicionar um comentário aqui. Se você já estiver registrado, faça logon. Se você ainda não estiver registrado, registre-se e faça logon.