Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add multiple tags for a single field

Hello,

I need to be able to add multiple tags to a single field. My *.xls file has 2 columns, each field is referenced only once, and I'd like to use ',' (comma separator) between each tag.

My following code only retrieves the first tag, not the others. why?

FieldTags:

mapping LOAD [Field],

     subfield(Tag,',') as Tag

FROM QVMetadata.xls

(biff, embedded labels, table is Fields$)

where Not IsNull(Tag);

tag fields using FieldTags;

2 Replies
Not applicable
Author

Here is a simple example. How do I add more than 2 tags to a single fields?

Not applicable
Author

Hi Nicolas,

The problem is that the mapping function will only get the first value it encounters so, in order to tag the field with multiple tags you either need to create another map or, individually add the tags with the tag field function.

Regards