Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I uploaded the data from the excel and few rows with zero values/Null rows are all created. How I can delete this null rows in my data manager editor?
Thanks in advance
Regards
Praneeth Pasari
Hi Praneet,
Is this at the end of you document of between the data? Because if it's at the end, it's not a real problem. Do you also see this in the Data Model Viewer?
Jordy
Climber
Yes, I can.
But I would also like to know, how to delete a specific row data in the data manager as we do in python or excel.
There is no possibility to actually 'delete' a row in Qlik. What you can do is go to the Data Load Editor, unlock your script and add the statement:
Where not isnull([YourField])
or
Where [YourField] <> ''
YourField should be your table key field, the unique field in your table.
Jordy
Climber
I don't have any unique field in my data as the data is the project reporting data for every month. I had consolidated all the projects data in to one Database so most of the data is repetitive untill or unless I use two column together. I wont be able to have unique field.
Can I just say isnull to my complete database to remove all empty rows ?, if so how I can do it ?
If you see the screenshot the summary of the column shows me that there are 12% of values are null, how I can remove them ?
No problem, you can do this on Reporting Month:
Where not isnull([Reporting Month])
This will leave you without any empty rows.
Jordy
Climber
I tried but I am getting below error.
I see that you are using this within your auto generated calendar, is that correct?
You need to do this at the end of you fact table! The reason why you see this error is because you misplaced the ; because your where needs to be before the ; . You get that?
Jordy
Climber
Could you please elobrate a bit more.
In my autogenerate section I have only two sub section
1. Data loaded
2 Auto calender
Do I need to create a new section (using add symbol on the left ) and run the script ?