Problem in transpose data in script.

[vijayit43]

Hi Expert,

               In Excel Data are this type..

	Assign User
QV Name	Dashboard1	Dashboard2	Dashboard3	Dashboard4	Dashboard5	Dashboard6
	User1	User1	User2	User1	User2	User1
	user2	user3	user3	user3	user4	user2
	user3	user4	user4	user4	user5	user4

But when we load script then we want data at this type.

Qv Name	User
Dashboard1	User1
Dashboard1	user2
Dashboard1	user3
Dashboard2	User1
Dashboard2	user3
Dashboard2	user4
Dashboard3	User2
Dashboard3	user3
Dashboard3	user4
Dashboard4	User1
Dashboard4	user3
Dashboard4	user4
Dashboard5	User2
Dashboard5	user4
Dashboard5	user5
Dashboard6	User1
Dashboard6	user2
Dashboard6	user4

How to achieve this please suggest..

[#2]

crosstable (QVName, User)

load * inline

[

Dashboard1, Dashboard2, Dashboard3 ,Dashboard4, Dashboard5 ,Dashboard6

User1,User1, User2 ,User1 ,User2, User1

user2, user3 ,user3, user3 ,user4, user2

user3, user4, user4, user4 ,user5 ,user4

];

[SergeyMak · Accepted solution]

You need to use crosstable function

Try this script

CrossTable ('QV Name','Assign User',1)

LOAD 1 AS Tmp, * INLINE [

Dashboard1,Dashboard2,Dashboard3,Dashboard4,Dashboard5,Dashboard6

User1,User1,User2,User1,User2,User1

user2,user3,user3,user3,user4,user2

user3,user4,user4,user4,user5,user4

];

DROP Field Tmp;

Regards,

Sergey

[vijayit43]

how to fetch from excel.

[SergeyMak]

Just load data from excel as usual and add these lines before

CrossTable ('QV Name','Assign User',1)

LOAD 1 AS Tmp, * ;

And this line after your load from excel

DROP Field Tmp;