Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We required IDs data contains 'Test3', Please refer the sample screenshot below.
LOAD * INLINE [
ID, Name, Category
1, dsfdsgdfg, Test1
1, dsfdsgdfg, Test2
1, dsfdsgdfg, Test3
1, dsfdsgdfg, Test4
2, bffgtr, Test1
2, bffgtr, Test2
3, gfhtrhtr, Test2
3, gfhtrhtr, Test3
3, gfhtrhtr, Test4
4, nghntnry45, Test2
5, gfngfbw56, Test1
5, gfngfbw56, Test2
5, gfngfbw56, Test3
5, gfngfbw56, Test4
6, jkmtyerea, Test2
6, jkmtyerea, Test3
7, hgjtyurty, Test1
7, hgjtyurty, Test2
7, hgjtyurty, Test4
8, kjljtytr, Test1
8, kjljtytr, Test2
8, kjljtytr, Test4
9, yutrytry, Test3
];
If you follow vegar's method your datamodel will contain only what you desire as output .
please specify if you want the output only on the UI or the full datamodel.
latter is vegars approach.
if you want the former you can modify vegars code and add a flag on all the ids which has Test3