topic Re: qlikview value in a row as '------------' while loading in QlikView

qlikview value in a row as '------------' while loading

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team

I have a column Code where I am getting some dummy value as hyphens '-------------'. I want to remove that trailing hyphens row while loading the data.

Please help

Thanks in advance

Re: qlikview value in a row as '------------' while loading

sunny_talwar — Tue, 27 Jun 2017 18:27:41 GMT

Can you show few sample data points to see how exactly they might look like

Re: qlikview value in a row as '------------' while loading

Anil_Babu_Samineni — Tue, 27 Jun 2017 18:39:34 GMT

Sristi, We can achieve these number of ways

Load * from Table Where Not WildMatch(FieldName, '--*')

Load * from Table where FieldName <> '---';

or could be more ways, If you provide little more information