SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Oder of Input in a User Written code node

Reply
Occasional Contributor
Posts: 6

Oder of Input in a User Written code node

Hi,

I wanted to ask if there is a way to change the order of input tables in a User written code.  Say I have 4 tables as input to a User Written code node, can I influence the the order these are linked to User written code node so the relevant generated macro variables in the user defined code node are created as expected.

Thanks,

Super Contributor
Posts: 356

Oder of Input in a User Written code node

My only guess would be the order that you link the data nodes to the User written code node.

Barry

Occasional Contributor
Posts: 6

Oder of Input in a User Written code node

Posted in reply to twocanbazza

Thanks for the reply Barry.

I though the same but haven't had the chance to test it yet. I thought there would have been some option within connection option to control the inputs, as some out jobs have over 15 inputs, which will be time consuming prone to error to manually change the order of the link.

Thanks

Super User
Posts: 5,424

Oder of Input in a User Written code node

The User Written Code Transformation is very generic. It means that there are very little that can be customized in terms of metadata and dynamic macro variables. If you have some kind of naming standard of your input tables, you might can develop some macro code to map/find specific input tables that has special tasks in the transformation.

One work-around could be to use an User Written Transform. It will let you specify specific input data to specific macro variable names and descriptions.

Then can use the Connections windows to see/map input to specific input slots.

/Linus

Data never sleeps
Occasional Contributor
Posts: 17

Re: Oder of Input in a User Written code node

Yes you can change the order but it is a little vague.  You are correct in that you need to go to the "Connections" option (Right Mouse Click on the User Written node).  Here are the steps which I just verified by testing;

1.  Right click on User Written node and select "Connections".

2.  Click the "..." button and select "<none>" .  Then select OK

3.  Now choose the order you need via the "..." button and selecting the datasets.

4.  Your order of input datasets has changed

See the below screenshots showing it. 

P.S.  My preferred rate is $1600 per day Smiley Wink

Cam

Ask a Question
Discussion stats
  • 4 replies
  • 273 views
  • 3 likes
  • 4 in conversation