Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a excel sheet of which i have to put a dashboard , In my excel sheet i have columns names as
Tech:rahul, Tech:padma, Tech:manoj,Tech:asha ,Tech:vinod
my question is i want to bring all the name under one column as Tech ,.
How do i do that
You can also use individual columns instead of *
CrossTable(Name, Data, 7)
LOAD [Sentiment Score],
Sentiment,
Date,
[Source Name],
Author,
Location,
[Fb Likes/Youtube view],
[Topic: Calvin Klein],
Tech:vinod,
Tech:asha,
Tech:rahul,
Tech:raj,
Tech:neetha,
Tech:seema
FROM
[Create a dash board.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hi Anand super bro
Its working But how about the table contenet which also has topic : jeans,
what should i do for that
Hi Wrstler,
CrossTable(Jeans, Data)
LOAD [Topic Content ID],
[Topic: Calvin Klein] as Calvin_Klein,
[Topic: Diesel] as Diesel,
[Topic: Killer Jeans] as Killer,
[Topic: Lee Cooper Jeans] as Lee_Cooper,
[Topic: Lee Jeans] as Lee,
[Topic: Levis] as Levis,
[Topic: Pepe Jeans London] as Pepe,
[Topic: Spykar] as Spykar,
[Topic: Wrangler Jeans] as Wrangler
FROM
(ooxml, embedded labels, table is Sheet3);
you can use this it will work.
Thanks bro its working ,