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

[kumarkp412]

Hi Arul,

Just try this.

You can make it just rename the Group name into Amount .Then if you are using default association it will take the Stregity values into ur first table.

Thanks

Kumar

[vipin_mishra479]

no its not possible above i have attached the new application

[arulsettu]

[varshavig12]

eg: output :

JP

west

33

New

[Chanty4u]

try below script

t1:

LOAD * INLINE [

    Customer, Amount

    A, 111

    B, 222

    C, 333

    ];

LOAD *, Amount as Group

Resident t1;

LOAD * INLINE [

    Group, Stregity

    111, New

    222, Middle

    333, Old

];

[varshavig12]

Can you please update the output as per the new data ?

[susovan]

Hi Vipin,

You can also try this process

Table1:

LOAD Customer,

     Amount as Group

FROM

[Example Test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join

Table2:

LOAD * INLINE [

    Group, Stregity

    111, New

    222, Middel

    333, Old

    121, Avg

    221, Check

    332, Done

];

[vipin_mishra479]

Please check my second attached file is t the posible that with out link this will be posible

[varshavig12]

Do you mean that you want to fetch data from different without using join (without link) ?

[vipin_mishra479]

yes i don't want to join i don't want to link but due to how i want this in my chart