"Click to Propose Join" Button in SAP BODS??

[Former Member]

What is the use of "Click to Propose Join" Button found in sap bods query transform Join options tab. Weather i click it or not, everything works fine. So, What is it's purpose?

Thanks in Advance

-- Adithya

[NielsWeigel · Accepted solution]

Hi Adithya,

When you have multiple tables (schema) in your Transform Input and want to create an output Schema with joined information from multiple input Schema, you need to join them either manually or let Data Services Designer propose you what might be the best joining condition for the two or more input schemas.

Example: Two input tables CUSTOMER and ADDRESS and you want to create a flatten Schema as output containing a customer with its address. Then you either need to manually create the join condition customer.ID =address.CUSTOMER_ID using a left join condition, or let DS Designer try to find the proposed join condition for you...

Best regards,

Niels

[Former Member · Accepted solution]

Thanks for your time and Information Sir : )

Could you please answer this for me : "Month to Month number conversion in SAP BODS".