delete certain rows from existing table - Qlik Community

Report Inappropriate Content · ‎2014-03-26

Hi Experts,

I haave a table called tempPostal which contains pincode, lonitude, latitude and coordinates(concat of long and lat). There are few rows where lon and lat are null. I want to filter out those records from tempPostal and have only valid data in it.

How do i achieve this?

Thank you.

PrashantSangle · ‎2014-03-26

Hi,

You can do this at script level

Add where clause like

Where lonitude<>'' or latitude <> ''

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-03-26

Hi Pramod, PFA.

Thanks,

Ram

Report Inappropriate Content · ‎2014-03-26

In the load script at the very end of the FROM clause add in

Where Len(Trim(Field)) > 0 ;