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,
Try like this:
table1:
Load
[Material code]
from ABC.xlsx;
left join
load
[Material code],
'0' as Dummyfield
resident table1;
Regards,
KC
Your Understanding is correct only..But I need for all Material Code
I need like this below screenshot..
Hi Jyothish,
Thanks for your rly.But this concept is not suite for my expectation.if u don'tundrstand pls let me know.
Hi Anil,
Is this possible to create? Can u help me.
Thanks in advance
You will get 0 for all material code. Can you explain your requirement in detail ?
Br,
KC
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
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.
Try my below code..
Regards,
KC
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.
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: