New Field Creation Out of Two fileds

[Anonymous]

Hi Gurus,

I have a standalone table in my table, as its having less number of records.

I have User Details as old user, new user, I would like to merge them into one column as User, so that I can use the same as dimension.

Could you please provide your inputs for same.

Thanks & Regards,

MK

[sunny_talwar]

meetmrudul wrote:

I have a standalone table in my table, as its having less number of records.

Having difficulty visualizing this. Do you have a sample you can provide? or few lines of sample data and your expected output?

[Kushal_Chawda]

Concatenate Table by creating Flag as old and New user

Data:

LOAD  [OLD USER] as User,

            'OldUser' as Flag

             ......

FROM Table

concatenate(Data)

LOAD  [NEW USER] as User,

           'NewUser' as Flag

            ......

FROM Table

[Anonymous]

I have a standalone table in my datamodel, as its having less number of records.

[Anonymous]

in this case, it will create duplicate record

[sunny_talwar]

Can you show your datamodel? What do you mean when you say stand alone table?

[avinashelite]

please share the sample data set and required output so that we can help you out with the same