How to Create Dummy records

[Anonymous]

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

[jyothish8807]

Hi Sindhu,

Then try like this:

load

[Material code],

'0' as [Stock Value]

from Table:

Conctenate

Fact:

Load

[Material code],

[Stock Value]

from .....;

[sasikanth]

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]))

[Anonymous]

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.

[Anil_Babu_Samineni]

Even 1 Lakh records we use only one line of script, Does it make sense?

LOAD [Material Code],'0' as [Stock Value] Resident Sample;

[Muthu]

Please check the below qvw and see whether it helps.

Adding '0' will regenerate for all the records !