Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Sep 9 at 4:13 PM I can't figure out the problem.... can you give us more details? (For example t1 to t6 have the same structure? Do they have different structures? What's the structure of the "single file"? How do you join the different tables? (This has to do with the structure of the tables...)
At least, if we knew the structure of that "single file" we could offer more ideas
PS. my first bet was to use left outer join....
| | | ---------------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. __.____._ |   _.____.__ |
