cross table

[#1]

Hi,
i m making a dashboard from hive table.
i need to make a cross table.
i have tried the following command

CrossTable(sentiment_category, sentiment_score )
LOAD Key,
actor,
bond_girl,
car,
director,
Resident Main;

but it does not work.

kindly help

Regards teja.

[#2]

Hi,

Maybe you can use

CrossTable(sentiment_category, sentiment_score,2,4 )
LOAD Key,
actor,
bond_girl,
car,
director,
Resident Main;

Regards,

Amay

[#3]

Hello Teja,

Please post your requirement here. how you need the output.

Thanks,

Sampath

[#4]

Hi sampath,

Am having a table which contains 10 different columns,

i need those columns to be appeared as rows.

Regards

teja.

[#5]

try this

crosstable(category,value,20)

load

Sr.No

Created_at

user:id_str,

user:follower_count,

user:favourites_count,

user:created_at,

user:screen_name,

user:name,

user:lang,

user:listed_count,

user:statuses_count,

user:geo_enabled,

user:location,

user:friends_count,

user:time_zone,

user:utc_offset,

retweet_count,

retweeted_status:retweet_count,

retweeted_status:id_str,

retweeted_status:user:id_str,

Actor,

Bond_Girl,

Car,

Director,

James_Bond,

Music,

Production_House,

Trailer Villian Writer

     from table;

[nizamsha]

CrossTable(sentiment_category, sentiment_score,2 )

LOAD Key,

actor,

bond_girl,

car,

director,

Resident Main;

Try this one

[#7]

Check the example attached

[#8]

hi,

Its not working

Regards

Tejavardhan.

[#9]

hi sampath,

Am using qlikview personnel edition i cant open please can u help me in other way

Regards,

Tejavardhan

[#10]

Hi,

this code is working fine when am using excel sheet but i need data from hive table when am trying the above query its not working.

regards,

Tejavardhan