Forum Discussion
How to delete unwanted rows?
I have a CSV dataset where I only want to load the Imports and Exports rows. I have filtered it accordingly.
However, I want to remove the remaining rows which are simply selection criteria and are taking up space in my model.
Can someone please help with removing the unnecessary rows ? Everything except the Import and Export Rows.
thank you
Yes, you can use another OR() there.
7 Replies
Anonymous , Using a filter from UI should work. Or create a calculated column with flag 1 and 0 based on the value and then select 1 or 0 and filter
Hi,
Write this custom formula in the Query Editor
=if [Trade Direction]="Imports" or [Trade Direction]="Exports" then 1 else 0
The language of the Query Editor (Mashup or "M") is case sensitive.
