How to append text before the real data?

[priyav24]

Hello Everybody,

I have data Say

Flight

1

2

3

4

5

10..I want to append text before this data like

Flight

XX1

XX2

XX3

XX4

XX5

XX6

XX10

Thank in advance...

Regards,

priya

[#2]

Hi priya

how about

1 as 'xx1'

2 as 'xx2'

or

'xx' + 1

regards

Petra

[#3]

load

Flight & Flight1 as new_Flight

or

a:

LOAD * INLINE [

    Flight

    1

    2

    3

    4

    5

    10

];

LOAD 'xx' & Flight as n Resident a;

[er_mohit]

a:

LOAD * Inline [

Flight

1

2

3

4

5

];

NoConcatenate

LOAD 'XX' & Flight as Flight

Resident a;

DROP Table a;

[priyav24]

I wanted to do something in expression

[er_mohit · Accepted solution]

a:

LOAD * Inline [

Flight

1

2

3

4

5

];

take dimension Flight

add expression

'XX' & Flight

[er_mohit]

if it is correct as per your requirement then you have to mark it as correct answer to closed this thread. So that it might be helpful for other developer

Regards

Mohit