Hi All,
I am working on one requirement where I need to convert the Column value in to Row for one set of record.
My source table is getting populated from json file.
Please help me to achieve this .
Thanks in advance.
Regards,
Vipin Jha
Hi All,
I am working on one requirement where I need to convert the Column value in to Row for one set of record.
My source table is getting populated from json file.
Please help me to achieve this .
Thanks in advance.
Regards,
Vipin Jha
This should help you
I do not have to perform any aggregation on my data. I given example aggregation has been use
PIVOT requires an aggregate function. Your example would use MAX() or MIN(); they work for any data type, and if you only have one value then they'd both return the same thing.
@vipin_jha123
Hi, Vipin,
If you'll take the time to provide the source data in a readily consumable format (use a CREATE TABLE and provide the data in the form o INSERT/VALUES), I'll show you how with code.
Also, PIVOT kinda sucks for performance and flexibility. What you really want is a CROSSTAB and, again, if you provide the original data in the readily consumable format I just described, I'll show you how.