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,

Try like this:

table1:

Load

[Material code]

from ABC.xlsx;

left join

load

[Material code],

'0' as Dummyfield

resident table1;

Regards,

KC

[Anonymous]

Your Understanding is correct only..But I need for all Material Code

I need like this below screenshot..

[Anonymous]

Hi Jyothish,

Thanks for your rly.But this concept is not suite for my expectation.if u don'tundrstand pls let me know.

[Anonymous]

Hi Anil,

Is this possible to create? Can u help me.

Thanks in advance

[jyothish8807]

You will get 0 for all material code. Can you explain your requirement in detail ?

Br,

KC

[jyothish8807]

Try like this:

Try like this:

table1:

Load

[Material code],

[Stock Value]

from ABC.xlsx;

left join

load

[Material code],

'0' as [Stock Value]

resident table1;

Regards,

KC

[Anonymous]

Hi Jyothish,

Thanks for ur response.

I have two tables one is master(item master) and one is fact table. Material Code should fall with the value and zero. Please refer attached screen shot.

[jyothish8807]

Try my below code..

Regards,

KC

[Anonymous]

Hi Jyothish,

Material Code is in master table and stock value is in fact table..did u get dt? I have to add 'Zero' in material code itself, not in the stock value.

Thanks again for ur Fast response.

[Anil_Babu_Samineni]

I am not sure, By the way helps to you

Sample:

LOAD * Inline [

Material Code, Stock Value

ABC12, 10

DFE23, 10

kfdfds43, 20

fsd32, 30

klt67, 40

];

Join

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

Output: