Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Field called Material code which contains some data.
For Example:
Material Code:
1
2
3
4
5
I have to add 0 as a dummy value for each Records.How can I do this in the script.Could Anyone help me in this
Thanks
Hi Sindhu,
Then try like this:
load
[Material code],
'0' as [Stock Value]
from Table:
Conctenate
Fact:
Load
[Material code],
[Stock Value]
from .....;
HI,
If your intention is to display a ZERO if no value then you can handle it from pivot table expression.
have you tried the below Exp?
=Sum(Aggr(Sum(if isnull([Stock Value]),0,[Stock Value]),[Material code]))
Thanks For your response.
We have around 1 lakh of Material code.How can we do this by Inline load.Suggest me Any other option pls.
Even 1 Lakh records we use only one line of script, Does it make sense?
LOAD [Material Code],'0' as [Stock Value] Resident Sample;
Please check the below qvw and see whether it helps.
Adding '0' will regenerate for all the records !