Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

2 Replies
sunny_talwar

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

Anil_Babu_Samineni

Sristi, We can achieve these number of ways

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

Or

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful