want to generate unique row no and column no

[nizamsha]

HI all

  I have attached  a sample sample snap shot .. what i want is

Out put should be like this

Private Markets	1
SS Private Equity Index- All PE	2
Buyout	3
SS Private Equity Index- Buyout	4
Mega Cap	5
SS Private Equity Index- Mega Cap	6
Buyout Mega Cap Fund	7
SS Private Equity Index- Mid Cap Fund	8

I want to generate a unique no  like this ,,how can i generate a no by seeing the snap shot and the output u can get a clear idea

[nizamsha]

HI

   How can i get the output like ths .

Private Markets	1
SS Private Equity Index- All PE	2
Buyout	3
SS Private Equity Index- Buyout	4
Mega Cap	5
SS Private Equity Index- Mega Cap	6
Buyout Mega Cap Fund	7
SS Private Equity Index- Mid Cap Fund	8

.kindly go through the snap shot and the output u can get a clear idea ..

[nizamsha]

HI

How can i achieve this output..

i have attached snapshot.

[#4]

try this

Temp:

load

[Investment Category],Strategy,[Sub Strategy],Fund,Index from table;

T1:

load

[Investment] as combine resident Temp;

concatenate(T1)

load

Index as combine resident Temp;

concatenate(T1)

load

Strategy as combine resident Temp;

concatenate(T1)

load

[Sub Strategy] as combine resident Temp;

concatenate(T1)

load

Fund as combine resident Temp;

Final:

noconcatenate

load *, rowno() as key resident T1;

Drop table T1;

[nizamsha]

HI  Vishwaranjan Kumar

     I Checked that but its not coming in this order

Private Markets	1
SS Private Equity Index- All PE	2
Buyout	3
SS Private Equity Index- Buyout	4
Mega Cap	5
SS Private Equity Index- Mega Cap	6
Buyout Mega Cap Fund	7
SS Private Equity Index- Mid Cap Fund	8

[#6]

hi

see attachment, this is demo made according to your requirement. hope this helps you

[nizamsha]

VISHWARANJAN

i had a look at ur qvd and qvw but out put is not coming what i expected ..now i have attached qvd and qvw so u can clearly understand what i was excepting

[nizamsha]

Hi All

from yesterday onwards i am facing one issue but cant fix it could anyone help me to fix it

i can explain clearly so that i can get a response from ur side,

consider i have a excel with data like this

NO     A            B           C                   D                    E

1      APPLE                                                             IPHONE

2                     microsoft                       Computer

3                                                                               Mobile

4        Lenovo                   Laptop           15inch     

finally i want a output like this

Field1       field2

APPLE     1    

IPHONE    2

microsoft   3   

Computer  4 

Mobile      5    

Lenovo     6

Laptop     7

15inch      8                                                                               

[Gysbert_Wassenaar · Accepted solution]

See attached example

[nizamsha]

Perfect Thanks a lot