Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two columns Gender and ETP code and want to remove redundancy so how can I concatenate two columns
You mean this?
LOAD Gender&[ETP code] as Key resident TableName;
a sample set of data will get you better suggestions
Thanks
Please share some sample app ...
or you can try like this
LOAD Gender&[ETP code] as NewKey;
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
Hi,
You mean composite key?!
Maybe like this-
Load
*,
Gender&'-'&[ETP Code] as [Gender Key]
Resident table_name;
Regards,
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 ?
Please share some sample application.
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 ?
How can I share my qvw here?