Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Im display a table data where i need to restrict column data based on only condition.
i dont need any group hence left group field empty.
aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2),)
aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}ID),)
I alos tried this way.
only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)
only({<[INVESTIGATION.Inv with Activity] ={0}>}ID)
both are giving blank(-) values even though data is there...
Plz help
Thanks,
Raghav
Please explain bit more clear or with any sample data to explain the problem
May this
only( {1} {<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)
Or
only({1} {<[INVESTIGATION.Inv with Activity] ={0}>}ID)
t1:
owner, ID
a,1
b,2
c,4
t2:
Id,Activy
1,0
2,0
I need to filter data based on only( {1} {<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)
so that i can see data only as below in table.
owner id
a 1
b 2
There is no primary key in your two tables, how can you map to show them. Is there Any other field which are hidden mapping because your expression looks okay to me
Hi Raghav,
This is what I loaded (Notice the ID field, instead of using Id)
t1:
load * Inline [
owner, ID
a,1
b,2
c,4];
t2:
NoConcatenate
Load * inline [
ID,Activy
1,0
2,0];
And this is how the Table is created in the front end:
If you want to get rid of the Null, you need to not show null values or to populate all the possible activities as activity 4 is not in T2
I hope this helps,
Luis
Or something simpler:
>>aggr(only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2),)
Syntax error - Aggr(0 needs a dimension value.
>>Only({<[INVESTIGATION.Inv with Activity] ={0}>}Owner2)
Only() returns a value if there is only one possible value for the expression and null if there is more than one.
Its not clear what you are trying to do. Perhaps you could claridy that and get more useful assistance.