topic Re: import recipients in Qlik NPrinting

import recipients

alexpanjhc — Fri, 17 Jun 2016 21:31:02 GMT

I imported a couple of hundred recipients and I need to have the IDs in the Name field, but I can't figure out a way to make the ID to automatically fill the Name field.

Suggestions?

I manually did the first 2.

Thank you!

Re: import recipients

MarcoWedel — Sun, 19 Jun 2016 00:02:54 GMT

Can you elaborate on your requirement?

Without explaining how your IDs can be calculated/generated/loaded , your question is hard to answer.

regards

Marco

Re: import recipients

Anonymous — Sun, 19 Jun 2016 10:31:16 GMT

If I understand you correctly, you can use a simple functions like Replace() or TextBetween() and Capitalize() on the description column.

When loading the table you can add the following:

LOAD

Capitalize(TextBetween(Description, ' ', '@') as [Name field], //text between the first space and the '@' sign

Description

From ...

and if your data is more complicated then Qlikview has many options using Index(), Replace(), Left(),Right(), Trim() and other string manipulations.

Re: import recipients

alexpanjhc — Mon, 20 Jun 2016 12:19:36 GMT

Marco,

I have my ID and emails, it is just when I imported them, I am not sure how to map the ID under the name section.

Re: import recipients

alexpanjhc — Mon, 20 Jun 2016 12:26:28 GMT

Eyal

here is what I see, and after I did the import, I wanted to have the IDs under the Name (in my original post)

I hope this is clearer.

Thanks!

Re: import recipients

Anil_Babu_Samineni — Mon, 20 Jun 2016 14:09:07 GMT

Alex,

Where do you get this Text. If this data coming from Excel i have simple logic ..Let me know ??

Re: import recipients

alexpanjhc — Mon, 20 Jun 2016 17:42:44 GMT

Anil

it is from a Qlikview table that I created.Is it what you are asking?

Re: import recipients

Daniel_Jenkins — Mon, 20 Jun 2016 23:30:09 GMT

Hi Alex,

ID is a key field and should be unique for each recipient. You can have many recipients with the same name but not the same ID. Each recipient can have multiple filters - which is what I think you are trying to achieve. Here is a link to all the relevant tutorials/documentation: QlikView NPrinting 16 Tutorials - Recipients & Users

HTH - Daniel.

Re: import recipients

Anil_Babu_Samineni — Tue, 21 Jun 2016 07:30:32 GMT

No, I am asking about the Data Source (Excel / DB / xml)