https://communities.sas.com/t5/Moving-to-SAS-Viya/Column-mapping-in-load-table-step-in-SAS-Viya-4-0/m-p/926137#M74 <P>We are migrating SAS 9.4 DI jobs to SAS Viya 4. In a DI jobs, when we migrated table loader transformation to load table step, column mappings are not migrated properly. Columns with not matching names are not mapped. In sas 9.4 DI table loader transformation, we can map any column to anyone irrespective of its name as per data but in SAS Viya, this is a big concern. Can anyone help me with any solution because client has lots of DI jobs to migrate to SAS Viya.</P> Sat, 27 Apr 2024 09:51:06 GMT ParitoshACN 2024-04-27T09:51:06Z https://communities.sas.com/t5/Moving-to-SAS-Viya/Column-mapping-in-load-table-step-in-SAS-Viya-4-0/m-p/926137#M74 <P>We are migrating SAS 9.4 DI jobs to SAS Viya 4. In a DI jobs, when we migrated table loader transformation to load table step, column mappings are not migrated properly. Columns with not matching names are not mapped. In sas 9.4 DI table loader transformation, we can map any column to anyone irrespective of its name as per data but in SAS Viya, this is a big concern. Can anyone help me with any solution because client has lots of DI jobs to migrate to SAS Viya.</P> Sat, 27 Apr 2024 09:51:06 GMT https://communities.sas.com/t5/Moving-to-SAS-Viya/Column-mapping-in-load-table-step-in-SAS-Viya-4-0/m-p/926137#M74 ParitoshACN 2024-04-27T09:51:06Z https://communities.sas.com/t5/Moving-to-SAS-Viya/Column-mapping-in-load-table-step-in-SAS-Viya-4-0/m-p/926191#M75 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/448657">@ParitoshACN</a>&nbsp;</P> <P>I suggest you contact SAS Tech Support with your concern.</P> <P>Be very specific about the SAS/DIS source version and the Viya/Studio Flow target version.</P> Sun, 28 Apr 2024 01:06:23 GMT https://communities.sas.com/t5/Moving-to-SAS-Viya/Column-mapping-in-load-table-step-in-SAS-Viya-4-0/m-p/926191#M75 Patrick 2024-04-28T01:06:23Z