Sorry to trouble @Patrick.Would you please help how to achive this please using user written node please. ... View more

Hi @Patrick , Looking at the picture you've posted it appears that you just want to transpose the data into a final target table which always gets fully replaced. So in this scenario couldn't you just have this final table as output of the transpose transformation itself (= a permanent yellow table) and get rid of the table loade   Actually i need in final table 12 reasons columns to be created please.so if i directly replace the work table with final target table.then i will get  only the columns based on source data.   Actually i have mentioned input data and expected output for which SAS DI job to be created in previous replies please. Currently. 1.Iam sorting the data using sort transformation 2.Using tranpose transformation and update the target column mapping option seeting to "Yes" please. 3.using table loader to load the data finally please.   Would you kindly advise if you have any other best ways to handle this In SASDI please ... View more

Thanks @andreas_lds , kindly find below SAS DI job snapshot.where iam using transpose transformation which is currently creating the reasons based on source data.in transpose out reason 5 columns are now getting created in Test environmnet  please. So in final target  table also i have manually created 12 columns for reason which are currently no data as expected. but what my challenge is : in future ,transpose output got created with 7 or 8 reason columns.then currently there is no column mapping (for reaosn 6,reason 7 .....reason12)from transpose mappiing to table loader mapping transofmration. These job will be running automatically as part of batch. please find the attached mapping where mapping missing for reason7 to reason12 please as there is no input from tranpose output please. but this is not the same case,it may have many reason with maximum 12 values please. please help.iam sorry if iam not conveyed my problem correctly please.kindly help.i did not cleary understood how append option will help on this please.kindly help please     ... View more

thanks @andreas_lds .i do not want to skip any NAME or any reason please. i tried proc transpose option.it will create just with 6 columns please. Actually i do n't want to manually create the columns 12 for reason value,please help .i have pasted sample inout data and output in previous chat please  ... View more

Hi @andreas_lds ,   Why do have 12 variables with the same content. Is this always the case? If not please post data matching what you have. And please explain the logic you want applied.   the values for 12 variables are taken from the source(oracle) table where these 12 reasons are storing it as under single column called "Reason".(please note that this table can have maximum 12 reasons or it might have less than this please for each "NAME" column).kindly have a look as sample input source code data below   Data t; input NAME $5. ID $3. STATUS $5. Reason $4.; datalines; 44104 DD NA AAG 8855 NA AAG 26910 AC TXN 8855 NA TXN 44104 DD NA TXN 44104 DD NA BAN 8855 NA CAH 8855 NA FAL 26910 AC RTM 8855 NA UPD 44104 DD NA SUC 26910 AC SUC ; run; and what in SAS i was told to do is to create the SAS dataset where to create 12 reason columns and display ID,NAME and status and corresponding reasons for each record and iam strugging to get as below ouput.i tried with transpose but was not properly output was not coming as desired with 12 values. please please help   NAME ID Status Reason_1 Reason_2 Reason_3 Reason_4 Reason_5 Reason_6 Reason_7 Reason_8 Reason_9 Reason_10 Reason_11 Reason_12 44104 DD NA AAG      TXN BAN SUC                 8855   NA AAG      TXN CAH FAL   UPD             26910   AC TXN RTM SUC                   ... View more

iam sorry kindly help whether you are able to see the sample data pasetd please.it is taking more space while pasting.so i have provided screen shot please ... View more

Thanks @Ksharp ,but iam not getting the expected output as desired,the same values are getting filled  on other reason columns please. @andreas_lds ,please find the sample input below :   Staus ID NAME Reason_0 Reason_1 Reason_2 Reason_3 Reason_4 Reason_5 Reason_6 Reason_7 Reason_8 Reason_9 Reason_10 Reason_11 Reason_12 NA DD 44104 AAG                  AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                      AAG                                     AAG                                     AAG                                     NA                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  8855 AAG                             AAG                                     AAG                                     AAG                                     AAG                                     AAG                                      AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                     AAG                                      Accepted                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         26910 Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       Txn                                       Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       Txn                                       Txn                                       NA                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  8855 Txn                                       Txn                                       Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       Txn                                       Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       NA DD 44104 Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       Txn                                       Txn                                       Txn                                       Txn                                        Txn                                       Txn                                       Txn                                       Txn                                       NA DD 44104 Bank Bank Bank Bank Bank Bank Bank Bank Bank Bank Bank Bank Bank NA                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  8855 Cache                                             Cache                                             Cache                                              Cache                                             Cache                                             Cache                                             Cache                                             Cache                                              Cache                                             Cache                                             Cache                                             Cache                                             Cache                                              NA                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  8855 Failed                                            Failed                                            Failed                                             Failed                                            Failed                                            Failed                                            Failed                                            Failed                                             Failed                                            Failed                                            Failed                                            Failed                                            Failed                                             Accepted                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  26910 Real-time                                         Real-tim                                          Real-tim                                           Real-tim                                          Real-tim                                          Real-tim                                          Real-tim                                          Real-tim                                           Real-tim                                          Real-tim                                          Real-tim                                          Real-tim                                          Real-tim                                           NA                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  8855 Update                                   Update                                   Update                                    Update                                   Update                                   Update                                   Update                                   Update                                   Update                                    Update                                   Update                                   Update                                   Update                                   NA DD 44104 Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Accepted                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  26910 Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                           Success                                               Expected output as below please :       ID NAME Status Reason_0 Reason_1 Reason_2 Reason_3 Reason_4 Reason_5 Reason_6 Reason_7 Reason_8 Reason_9 Reason_10 Reason_11 Reason_12 DD 44104 NA AAG      Txn       Bank Success                     8855 NA AAG      Txn       Cache Failed   Update                 26910 Accpeted Txn Real-time         Success                                   Sorry to trouble all please help ... View more

Thanks @PeterClemmensen .kindly find the  attached sample  input data and the output i need please ... View more

Thanks.I got it.i need to set "Update the metadata for the target tables option is set to Yes" which was missing in proc transpose node. ... View more