instead of outer join is there is any other function

[#1]

Hi.is there is any function other than join to use here to fullfill my requirement

[sunny_talwar]

What is your requirement?? There is no mention of your requirement any where in the post or the document

[swuehl]

Maybe. Would you like to tell us what your requirements are?

[Colin-Albert]

What are your requirements?

Have a look at this document on using ApplyMap.

Don't join - use Applymap instead

[jagan]

Hi,

Can you explain what you require exactly with an example and your expected output?  So that it would be easier to analyse and provide the solution.

If you don't want to join then you can use KEEP, it applies the join logic but maintains the two tables separately.

Or you can try ApplyMap() or Lookup().

Hope it helps you.

Regards,

jagan.

[#6]

Actually  i want to show stock of material based on plant wise and month, year wise. here i want to show stock of previous month if there is no stock in current month

[#7]

Actually  i want to show stock of material based on plant wise and month, year wise. here i want to show stock of previous month if there is no stock in current month

instead of outer join is there is any other function

[#8]

i fill the null values by giving is null function. by doing cross join my reload time so much high. so i want to reduce my reload time