flow insert rows

[YannRC]

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

[LinusH]

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

[YannRC]

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.

[LinusH]

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.

[YannRC]

it's stricly the same data on both table

[grace_sas]

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

[YannRC · Accepted solution]

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