https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420426#M12894 Well macro is the direction. But without writing the actual code for you...bu it will involve analysing how many input tables you have, and perform various %do loops for joining criteria.<BR />But, building a macro for joining various no of input table is signalling to me at least that there perhaps is not much reusability here. Why not use the standard Join transformation? Tue, 12 Dec 2017 11:31:01 GMT LinusH 2017-12-12T11:31:01Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420418#M12893 Tue, 19 Dec 2017 09:57:40 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420418#M12893 illusoryduck 2017-12-19T09:57:40Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420426#M12894 Well macro is the direction. But without writing the actual code for you...bu it will involve analysing how many input tables you have, and perform various %do loops for joining criteria.<BR />But, building a macro for joining various no of input table is signalling to me at least that there perhaps is not much reusability here. Why not use the standard Join transformation? Tue, 12 Dec 2017 11:31:01 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420426#M12894 LinusH 2017-12-12T11:31:01Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420724#M12909 I can't grasp the whole scenario in detail but is sounds like that each step could be preformed by other standard transformations.<BR />Again, the join part is not a good fit for a user written transformation. Wed, 13 Dec 2017 10:03:12 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-Studio-Custom-Transformation-Help/m-p/420724#M12909 LinusH 2017-12-13T10:03:12Z