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

[sunny_talwar]

May be Concatenate?

Table:

LOAD [Material Code],

     OtherFields....

FROM ...

Concatenate (Table)

LOAD 0 as [Material Code]

AutoGenerate 1;

[CarlosAMonroy]

Hi Sindhu,

Go to the script -> Insert Menu -> Load Statement -> Load Inline

LOAD * INLINE [

    Material, Plant

    A, AA

    B, BB

    C, CC

    D, DD

];

Hope that helps,

Carlos M

[Anonymous]

Hi,

Thanks for your rly.

But this concept is not generate '0' value for each record. But I need '0' for each material code.Can u help me to find solution.

[Anonymous]

Hi,

Thanks.

But I have more no of material code..How can I do by use Inline Load.

[Anil_Babu_Samineni]

Can you elaborate more about your expected result?

[Anonymous]

When I select one material code,it'll show some value. if there is no value means it should display 'Zero'.

I used pivot table and not getting proper result in 'Show all values and Suppress Zero values'.

So I planned to create some dummy data for each material code.

[Anil_Babu_Samineni]

Like this?

Or

[Anonymous]

Material Code ABC12 will have both Stock value as well as Zero value.  When there is no Stock value it should display Zero.This is what I want..

[Anil_Babu_Samineni]

I am sorry, If i misunderstand the Rek. Better if you provide sample data and expected result

From below, What are you expecting?