Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Vipin,
Its a bit strange requirement. But I believe what you want to do is to use the values from two different data island and use it in a straight table.
I have attached one qvw file, please check if it suffice your requirement.
Regards,
Sakir
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
No we don't link this inline with that table
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
];
then what is the use of inline table?
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.
Then share the real sample data, with expected o/p
here i have attached the updated one
Out put is same
Give alias name to "Group" as "Amount"