Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created document using straight table with Fields are fileld-1,fileld-2,fileld-3,filed-4.I want to add condition(where field-5='X') on this chat and I used this fileld-5 for applying condition without adding this column to straight table.
kindly provide me solution for this.
Many thanks for your valuable support.
Hi Srinivas,
Use the script as below:
Data:
LOAD * , WildMatch(fileld5,'X') as New_fileld5;
LOAD * INLINE [
fileld1,fileld2,fileld3,filed4,fileld5
1,a,b,c,X
1,a,b,d,Y
2,a,b,t,X
1,a,b,d,X
1,e,f,t,X
1,a,e,v,Y
2,a,b,t,X
1,a,b,t,X
];
But I don't want to see the Field-5 on the Straight Table.Just used this field for using condition on this chat only.
Kindly provide me solution for this.
Add the following set expression to your expression(s) for the table:
{<[Field-5] = {'X'}>}
For example:
Sum({<[Field-5] = {'X'}>} Amount)
Hi,
Try using Set analysis in your expression and don't add Field5 in Dimensions:
SUM({<Field5={"X"}>} [SalesAmount])
Hi Srinivas,
Did you manage to get the solution?