topic Re: flow insert rows in SAS Programming

flow insert rows

YannRC — Thu, 08 Jan 2026 05:57:42 GMT

hi, i try with a flow to insert rows. First, I create a table (APPEND) and after, a seconde table (APPEND_NEW) with the same column. It's a very simple case but it's to understand because it can be very helpful and I don't want to use program. But, I have this error. The flow say :

An error occurred while the system was executing the ‘Flux.flw’ flow.
The ‘Insert rows’ node has no matching columns between the source and the target

How can I fix it? thanks for your help

Re: flow insert rows

LinusH — Thu, 08 Jan 2026 07:24:39 GMT

It's hard from just one screenshot to tell what's wrong. Maybe you could attach the generated SAS code?

Re: flow insert rows

YannRC — Thu, 08 Jan 2026 07:31:22 GMT

Thanks !!

There is no code generated. When I click on code generated, i have this message.

Unable to generate code for the flow because there may be errors in some of the tasks.
The ‘Insert rows’ node has no matching columns between the source and the target.

Re: flow insert rows

LinusH — Thu, 08 Jan 2026 07:36:32 GMT

Ok, I don't have access to Studio Engineer at this point to try myself.
What does the "i" symbol say if you click/hoover over it?
You should compare data type and columns lengths for your datasets.

Re: flow insert rows

YannRC — Thu, 08 Jan 2026 08:49:42 GMT

it's stricly the same data on both table

Re: flow insert rows

grace_sas — Fri, 09 Jan 2026 20:30:47 GMT

Hi @YannRC

That error message certainly does not make sense when we can see that the mapping does exist. Are you able to drop the APPEND table and add a new one and does that work?

I would be happy to debug further through a technical support case if you want to open one.

SAS Help Center: Managing Support Cases

Regards,
Grace

Re: flow insert rows

YannRC — Mon, 12 Jan 2026 08:35:06 GMT

hanks, we update Viya to the last LTS version and it's now fixed.