Two fields into one

[prma7799]

Hi All,

I have one table in that have two fields like zone and state now I want combine two fields into one.

Please find the application and expected output.

Thanks

[kumarkp412]

Hi ,

You can able to get this by using hierarchy function .

[prma7799]

I don't want to create hierarchy I want this in as one field.

[anagharao]

Hi,

You could concatenate these fields into one.