Skip to Content
avatar image
Former Member

C4C reporting exchange / map values (avoid # / hashtag)

Hello experts,

I've got the # ( hashtag-sign) in my report and view other values, which I want to "exchange" or "map".

This is the original data.

now let's say. I want to exchange the value for column Gender like this:

1 = m

0 = <empty> (No # hashtag-sign)

2 = f

it should look like this afterwards

Does anyone know what is the best way to perform it?!

Thanks

Nik

screen01.png (108.5 kB)
screen02.png (109.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 14, 2017 at 04:05 AM

    Hi,

    You can try as follows :

    Convert Grid Display to Excel Table Display

    Just key in Excel formula in last column of the report result as

    =IF(F3="1","M",IF(F3="2","F"," " )) *assumption F3 is Gender column

    This formula will be auto adjusted to all rows.

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2017 at 04:13 PM

    So far, it seems like it is NOT possible to implement my requirement. Any other ideas @experts???

    Add comment
    10|10000 characters needed characters exceeded