Get the value in expression

[vipin_mishra479]

here i have attached the application and excel file.

I have a Amount by customer

like

Customer , Amount

A ,111

B , 222

C , 333

and here i have create one inline table where i define Group and Stregity

like

Group,Stregity

111,New

222,Middle

333,Old

So final result i want is

Customer  Amount  Stregity

    A             111       New

    B              222      Middle

    C             333       Old

[arulsettu]

change inline table like this

LOAD * INLINE [

    Amount, Stregity

    111, New

    222, Middel

    333, Old

    121, Avg

    221, Check

    332, Done

];

it will create relation between two tables

[vipin_mishra479]

No we don't link this inline with that table

[Anil_Babu_Samineni]

Or Try This

Load * inline[

Customer , Amount

A ,111

B , 222

C , 333];

Second:

Load * inline[

Group,Stregity

111,New

222,Middle

333,Old];

Load Group as Amount, Stregity Resident Second; Drop Table Second;

And then use this table box

Hope helpful

OR

Table1:

LOAD * INLINE [

Customer , Amount

A ,111

B , 222

C , 333

];

Table2:

LOAD *, Group as Amount INLINE [

    Group, Stregity

    111, New

    222, Middel

    333, Old

];

[arulsettu]

then what is the use of inline table?

[vipin_mishra479]

this is just example so that i can writ this way in Actually some of multiple amount i will get this amount so there is no way to link this with inline

And inline is just i want to know what was the stragity for this amount.

[Anil_Babu_Samineni]

Then share the real sample data, with expected o/p

[vipin_mishra479]

here i have attached the updated one

[vipin_mishra479]

Out put is same

[varshavig12]

Give alias name to "Group" as "Amount"