Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've two table like
Table1:
MaterialNo,
if([stockCategory]='Q', 'QualityHold') as Category,
StorageType;
Table2:
MaterialNo,
if([SoldToParty] = 02, 'CPP') as Category,
ShippingCondition;
How to use these two diff fields names out of same field name Category in a new table or so. Need help.
write concatenate between these 2 table
if both table have same column Names then it will auto concatenate.
Regards
How to use these two diff fields names out of same field name Category in a new table or so. Need help.
How to use them? I guess can you elaborate on what you are trying to do?
Could you please elaborate it?
As per my understanding you may use Concatenate().
hi,
StockCategory and SoldToParty fields values should come under new field Category. Will this posible?
Hi,
yes it is possible.
try with below script
Table1:
Load
MaterialNo,
if([stockCategory]='Q', 'QualityHold') as Category,
StorageType;
Concatenate
Load
MaterialNo,
if([SoldToParty] = 02, 'CPP') as Category,
ShippingCondition;
Regards
Try like,
Table1:
MaterialNo,
if([stockCategory]='Q', 'QualityHold') as Category,
StorageType;
Concatenate(Table1)
Table2:
MaterialNo,
if([SoldToParty] = 02, 'CPP') as Category,
ShippingCondition;