Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from R. N. Wilhite on Sep 10 at 7:45 AM So, the first thing that you've got to do is to not join (unless you make a
separate join for every possible combination). Give up the join and it's
pretty simple...
Neal
| | | ---------------Original Message---------------
From: stacyhobbs321
Sent: Monday, September 09, 2013 3:59 PM
Subject: How to Run a Component Conditionally in SAP BODS
I have a requirement here. I have 6 input tables. Say T1....T6.
Now on every execution of the job not every table will be available. I am reading those tables using query component( like select * from T1 etc).
On execution 1 may be only T3, T4, T6 is present.
On execution 2 may be only T1,T2,T3, T4,T5 is present
On execution 3 all tables may be present.
I am joining all 6 tables and creating 1 single file. How can I make these querty components conditional? Say If T3 is not present or any table is not present my job should not fail and should read from other 5 tables. Can anyone help, please? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
