Forum Discussion
Choosing rows and undo error
- 1 year ago
Hi parthkwatra17 ,
The problem is that you have added one step without giving it a name so you need to remove the line below
Concerning the selection part what you need to do is to do a filter condition so in this case would be something similar to:
= Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash")Replace the ColumnName by the column where you are filtering those values
So the last two lines of you query can be replaced by:
STEPNAME = Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash") in STEPNAMEChange the STEPNAME by whatever text you want be carefull if you want to have spaces it needs to be like #"This is my step name"
Hi parthkwatra17 ,
The problem is that you have added one step without giving it a name so you need to remove the line below
Concerning the selection part what you need to do is to do a filter condition so in this case would be something similar to:
= Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash")
Replace the ColumnName by the column where you are filtering those values
So the last two lines of you query can be replaced by:
STEPNAME = Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash")
in
STEPNAME
Change the STEPNAME by whatever text you want be carefull if you want to have spaces it needs to be like #"This is my step name"
hey, thanks for getting back.
I am still facing a little issue. Would it be possible to connect over a quick call?