Subfield

[nareshthavidishetty]

Hi all,

can anyone tell me where im going wrong with the subfield function

i got like these [Gross Sales,April'15,Unit Sales]

                        [free,April'15,Unit Sales]

                 [ salable,April'15,Unit Sales]

so i tried

subfield ( [April'15,',']) as April,

subfield([unit sales,',']) as Unit Sales etc

[MayilVahanan]

Hi

Got answer ??  Awesome

Credits goes to sunindia

[sunny_talwar]

Hahahaha, I can't really say how my solution worked for his scenario, but it seems that it somehow did .

[nareshthavidishetty]

thanks for the reply as im trying ur code mentioned above could u help me to understand little bit more please dont mind

[nareshthavidishetty]

CrossTable(FieldName, FieldValue, 😎 please explain these step in cross table as im bit unable to understand the crosstable

what if i got more columns so how should i need to specify parameters

[MayilVahanan]

Hi Naresh,

third parameters indicates from which field you need to be converted to generic.

In this example, from 8 field. So I mentioned as 8.

From help

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field name is the field to contain the attribute values.

data field name is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.