Merging two fields from diff tables with same field names? .

[MuraliPrasath]

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.

[PrashantSangle]

write concatenate between these 2 table

if both table have same column Names then it will auto concatenate.

Regards

[sunny_talwar]

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?

[senpradip007]

Could you please elaborate it?

As per my understanding you may use Concatenate().

[MuraliPrasath]

hi,

StockCategory and SoldToParty fields values should come under new field Category. Will this posible?

[PrashantSangle]

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

[senpradip007]

Try like,

Table1:

MaterialNo,

if([stockCategory]='Q', 'QualityHold') as Category,

StorageType;

Concatenate(Table1)

Table2:

MaterialNo,

if([SoldToParty] = 02, 'CPP') as Category,

ShippingCondition;