crosstable transformation( all fileds)

[raji6763]

hi,

can anyone help me on this?

i have 3 fields .i want to transpose all fields in to one field,so i used cross table function.i set qualifier field number as 1.

i am getting the below output. i can't see the field 3 value in field column

Advance Thanks,

raji

[marcus_sommer · Accepted solution]

A crosstable needs always at least one leading field on which the crosstable-transforming could be performed. If there is none you could just create one, for example with:

t1:
crosstable(field, value, 1) load recno() as RecNo, * inline [
…];

Afterwards you may drop the dummy-field again whereby in such case I would tend to keep it to be able to differ between the records.

drop fields RecNo from t1; // optional

- Marcus

[raji6763]

Thank you.it's working fine