Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Can you elaborate on your requirement?
Without explaining how your IDs can be calculated/generated/loaded , your question is hard to answer.
regards
Marco
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.
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.
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!
Alex,
Where do you get this Text. If this data coming from Excel i have simple logic ..Let me know ??
Anil
it is from a Qlikview table that I created.Is it what you are asking?
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.
No, I am asking about the Data Source (Excel / DB / xml)