how to concatenate two columns

[Anonymous]

Hi

I have two columns Gender and ETP code and want to remove redundancy so how can I concatenate two columns

[techvarun]

You mean this?

LOAD Gender&[ETP code] as Key resident TableName;

[techvarun]

a sample set of data will get you better suggestions

Thanks

[prma7799]

Please share some sample app ...

or you can try like this

LOAD Gender&[ETP code] as NewKey;

[Anonymous]

i want total on each chart to be same but I am not getting the same so i Want to concatenate the etpcode (primary key ) and the gender column

[mithilesh17]

Hi,

You mean composite key?!

Maybe like this-

Load

*,

Gender&'-'&[ETP Code] as [Gender Key]

Resident table_name;

Regards,

[Anonymous]

sir i want total on each chart should be same and I am not getting the same so can you please help me in resolving the issue ?

[prma7799]

Please share some sample application.

[Anonymous]

I have a query regarding a dashboard. I want a total of each charts(circled in black) to be same in pivot table but its not coming to be same.

So please tell me what may be the reason behind the same ?

[Anonymous]

How can I share my qvw here?