Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II
‎2017-03-08 03:28 AM

In Line

Hi,

I have in data table a field by the name of MAKE . I want to reclassify it the format given below  and make new filed MAKE1

I used the load in line command to do this. But some of make are duplicated.

Eg:  HONDA  is categorized both under MAKE and MAKE1 fields. Can you pls tell me whether can use better method other than Load in Line

  

MAKEMAKE1
PEUGEOTPEUGEOT
ASHOK LEYLANDASHOK LEYLAND
NOMAD ZOTYENOMAD ZOTYE
CHERRY QQCHERRY QQ
HYHUNDAIHYHUNDAI
HONDAHONDA
TATATATA
MAZDAMAZDA
PERODUAPERODUA
HUMBEROTHERS
CITROENOTHERS
JOYLONGOTHERS
MAHENDRAOTHERS
FIATOTHERS
OPELOTHERS
FOTONOTHERS
ASHOK LEYLANDOTHERS
HYHUNDAIOTHERS
MATRIXOTHERS
Labels (1)
Labels
1,552 Views
0 Likes
10 Replies
avinashelite
MVP
MVP
‎2017-03-08 04:44 AM

In response to upaliwije

Don't you have any key field with you could tag the values with ? because if others   belong to all the types then how you will identify to which type it belongs ...their should be an identifier rite ?

195 Views
0 Likes