Pivot Table query

[saumyashah90]

Hi Guyz,

I have application in column named a,b,c,d.

I have page in column names 1,2,3,4

So one application will have page

1-> b,c

2 -> b,d

3 -> a,c

Now I want to check a person  is going From what function of parameters To what function of parameters.

Source App	Source Page	Destination App	Destination Page
1	b	2	b
1	c	3	c

Should I make 2 more column with different names or can we do it in some other way?

[Gysbert_Wassenaar]

I don't understand your question. Can you post a source table and a result table?

[saumyashah90]

I want to know a person moves from which page of application to which page of other application.

Previous Page Name	Page Name
a	b
c	d
d	d
c	b

Here you can see from first row that a person saw page "a" and he moved to page "b" later. and similarly others.

These all pages comes under some application.

For example 2nd row "c" comes under application "1" and 4th row "c" comes under applicaton "4".

I have mapping like

Page Name	Application Name
a	1
a	4
b	3

So I want to know

From Previous Page name -> its  Application  To Page Name -> its Application

[Gysbert_Wassenaar]

For example 2nd row "c" comes under application "1" and 4th row "c" comes under applicaton "4".

Why? Where's the data that makes this clear?

[saumyashah90]

[Gysbert_Wassenaar]

How can a Page Name map to two applications?

[avinashelite]

Hi Saumya,

I think you have missed to mention the key parameters here!! in order to identify the application-page which  it belongs to we need to have application id along with it....Please share few more details about your application

[saumyashah90]

there is one id linked with it...unique id...you can take RowNo as of now