how do i seperate M and F on field Gender to different fields

[Anonymous]

Hello Peeps,

I want to seperate M and F to different fields, so i can load to different listbox.

[jagan · Accepted solution]

Hi,

In script try like this

Data:

LOAD

*,

If(DimensionName = 'M', DimensionName ) AS DimM,

If(DimensionName = 'F', DimensionName ) AS DimF

FROM DataSource;

Note : Replace DimensionName with your actual field name.

Hope this helps you.

Regards,

jagan.