Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.is there is any function other than join to use here to fullfill my requirement
What is your requirement?? There is no mention of your requirement any where in the post or the document
Maybe. Would you like to tell us what your requirements are?
What are your requirements?
Have a look at this document on using ApplyMap.
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.
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
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