Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexpanjhc
Specialist
Specialist

import recipients

Hi

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!

CaptureA.PNG

8 Replies
MarcoWedel

Can you elaborate on your requirement?

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

regards

Marco

Anonymous
Not applicable

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.

alexpanjhc
Specialist
Specialist
Author

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.

alexpanjhc
Specialist
Specialist
Author

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!

CaptureB.PNGCaptureC.PNG

Anil_Babu_Samineni

Alex,

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
alexpanjhc
Specialist
Specialist
Author

Anil

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

Daniel_Jenkins
Specialist III
Specialist III

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.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)