topic Re: Merging two fields from diff tables with same field names? . in QlikView

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

MuraliPrasath — Thu, 25 Feb 2016 09:21:14 GMT

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.

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

PrashantSangle — Thu, 25 Feb 2016 09:23:33 GMT

write concatenate between these 2 table

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

Regards

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

sunny_talwar — Thu, 25 Feb 2016 09:23:45 GMT

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?

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

senpradip007 — Thu, 25 Feb 2016 09:24:37 GMT

Could you please elaborate it?

As per my understanding you may use Concatenate().

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

MuraliPrasath — Thu, 25 Feb 2016 10:07:29 GMT

hi,

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

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

PrashantSangle — Thu, 25 Feb 2016 10:11:50 GMT

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

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

senpradip007 — Thu, 25 Feb 2016 10:17:30 GMT

Try like,

Table1:

MaterialNo,

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

StorageType;

Concatenate(Table1)

Table2:

MaterialNo,

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

ShippingCondition;