Combine 2 different field data in one...

[hamzabob1]

Dear Folks,

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

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.

[sunny_talwar]

May be like this:

Table:

LOAD FieldA as FieldC

FROM Source;

Concatenate (Table)

LOAD FieldB as FieldC

FROM Source;

[hamzabob1]

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

[sunny_talwar]

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;