Forum Discussion
Choosing rows and undo error
Hey, How do i go back to the steps orgininally done before the error was made and,
Is there any way I can select rows, like I selected columns?
Please help!
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"
5 Replies
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"
hey, thanks for getting back.
I am still facing a little issue. Would it be possible to connect over a quick call?
Hi parthkwatra17 ,
MFelix is right. Have you tried to do his suggestion? What is the showing after you did his suggestion?
MFelix right, you can add the name for this step, but if you whant to emove this step completely, make sure you hace remved the "," sign from the ned of the previous step.
In power query last step do not need "," at the end
