topic Re: Combine 2 different field data in one... in QlikView

Combine 2 different field data in one...

hamzabob1 — Wed, 27 Apr 2016 06:45:55 GMT

Dear Folks,

i have one problem can u please help me out...

Field A
abc xyz

Field A

abc

xyz

Field B
pqx
bbc

Expected Result:

Field C
abc
xyz
pqr
bbc

Both the Field A and Field B in same Table.

If it's possible in backend.

Thanks In advance.

Re: Combine 2 different field data in one...

sunny_talwar — Wed, 27 Apr 2016 15:53:25 GMT

May be like this:

Table:

LOAD FieldA as FieldC

FROM Source;

Concatenate (Table)

LOAD FieldB as FieldC

FROM Source;

Re: Combine 2 different field data in one...

hamzabob1 — Thu, 28 Apr 2016 05:22:45 GMT

hiii sunny

Thanks for your reply but its not working.

as i said both the fields are in same table.

is there any other option..

Regards,

Hamza

Re: Combine 2 different field data in one...

sunny_talwar — Thu, 28 Apr 2016 09:40:39 GMT

Doesn't matter, assuming this is how they look

TableName:

LOAD FieldA,

FieldB,

UniqueIdentifierField

FROM Source;

Add this at the bottom

LinkTable:

LOAD UniqueIdentifierField,

FieldA as FieldC,

'A' as FieldFlag

Resident TableName;

Concatenate (LinkTable)

LOAD UniqueIdentifier,

FieldB as FieldC,

'B' as FieldFlag

Resident TableName;