Discussion Board for collaboration related to QlikView App Development.
i am trying to concatenate two fields as
[Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1
this expression is not working for me
Iget output as - ABC(1760)
whereas it should be ABC(1760)
i tried using purgechar(Payer.Name,'-') it replaces ' - ' with ' ' '
trim gives same output as origanal expression one .
can anybody help?
Try this may be:
Replace([Payer.Name] &'('& [Payer.Number] &')', '- ', '') as Payer.Name1
Just tried your expression and it looks ok
Data: Load * Inline [ Payer.Name, Payer.Number ABC, 1760 ]; Data2: Load [Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1 Resident Data ;
Have you checked your payer.name data? Can you post the source data?
TextBetween( [Payer .Name],'-','') &'('& Payer.Number &')' as Payer.Name1
doesnt work for me
in source Payer Name is - 'ABC'
i tried all functions to get rid of quotes but not working
Will you be able to share a sample?
If the source contains is definitely - 'ABC' then use below as a work around. Let me know if this works
Load mid(Payer.Name,4,3) & '(' & Payer.Number & ')' As ConcatenatedPayer;