adding text

[thewillemzelluf]

Dear people,
I have a short question. Does anyone know how this can be realized?
For example, I now have a debtor code '234241'. I would like to make the following:

PAS|234241

PAS| stands for a group. Someone any idea how this can be done?
Greetings, Willem

[sunny_talwar]

Can you provide more details? Where are you trying to do this? Just for this this debtor code you want to add PAS|? or for every debtor code? Is PAS| coming from a field?

[thannila · Accepted solution]

Table:

load

'PAS|'&[debtor code] AS debtorcode,

* Inline

[

debtor code

234241

456789

];

DROP FIELD [debtor code];

CAN YOU PROVIDE MORE DETAIL?

[kfoudhaily]

as @sunny said, request is not very clear, but if I suppose that "debtor code" is your field and 'pas|' is only a string that you need to add to this qv field then your script should be like:

Load

'PAS|'&[debtor code]

from...

[balabhaskarqlik]

'PAS|' & [Debtor code] as [Debtor Code]

'Q' & ceil(month(MyDate)/3) & ' ' & year(MyDate) as Quarter

You can create same way on Calculated Dimension derive.

Or

Concat(), also use this

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringAggregat...